|
--------------------------------------------------------------------------------
-- SQL Script get physical object sizes
--
-- Purpose used to report the physical sizes of storage objects
-- Limitations None
-- Version 1.0
-- Oracle Version 10.2
-- Date 27 Nov 2007
--
-- Disclaimer This source code is provided free by Texas Memory Systems. This
-- software is provide without support, and the user assumes all
-- risk in it's use. You may use, or modify this in any way that
-- you choose
--------------------------------------------------------------------------------
set linesize 132
col file_name for a50
col mb for 999,999,999,999,999,999,999
select tablespace_name,
sum (bytes / 1024 / 1024) mb
from dba_data_files
group by tablespace_name
order by tablespace_name;
col member for a25
select * from v$log;
select * from v$logfile;
|