superSSD > Education > Oracle Performance Center > Code List

Oracle Performance Center - Code List

--------------------------------------------------------------------------------    
--  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;

Texas Memory Systems Sales - Call (713) 266-3200				Sign up for the RamSan Mailing List