Veritas InfoScale™ Operations Manager 7.4 ユーザーズガイド

select 'db_name=',value from v$parameter where name = 'db_name';

select 'total_tablespaces=',count(*) from v$tablespace;

select 'total_files=',SUM(c) from (select count (*) c from v$datafile union all select count (*) c from v$tempfile);

select 'total_logfiles=',count(*) from v$logfile;

select 'status=',status from v$instance;

select 'parallel=',parallel from v$instance;

select 'datsize=',sum(bytes) from dba_data_files;

select 'logsize=',sum(bytes) from sys.v_$log;

select 'tmpsize=',sum(bytes) from dba_temp_files;

select 'free_space=',sum(bytes) from dba_free_space;

select '--archive_log_files--' from dual;

select a.RECID,'++',a.NAME,'++',a.BLOCKS,'++',a.BLOCK_SIZE,'++',a.STATUS from v$archived_log a;

select '--redo_log_files--' from dual;

select [a.member], '++',nvl(b.status, 'null'),'++', b.group#, '++',b.bytes from v$logfile a, v$log b where a.group#=b.group#;

set colsep;

select '--tablespace_size--' from dual;

select t.tablespace_name tablespace,nvl(tsf.bytes,0) free FROM sys.dba_tablespaces t,sys.sm$ts_avail tsa,sys.sm$ts_free tsf WHERE t.tablespace_name = tsa.tablespace_name (+) AND t.tablespace_name = tsf.tablespace_name (+) AND t.tablespace_name not in ( select tablespace_name from dba_tablespaces where extent_management = 'LOCAL' and contents = 'TEMPORARY') UNION SELECT t.tablespace_name tablespace,nvl(lt.free,0) FROM sys.dba_tablespaces t,( SELECT h.tablespace_name,sum ((h.bytes_free + h.bytes_used) - p.bytes_used) free FROM sys.v_$temp_space_header h,sys.v_$Temp_extent_pool p wHERE p.file_id(+) = h.file_id group by h.tablespace_name ) lt WHERE t.tablespace_name = lt.tablespace_name ORDER BY 1;

select '--tablespace_status--' from dual;

select tablespace_name, status from sys.dba_tablespaces order by tablespace_name;

select '--tablespace_info--' from dual;

select * from (select ts.name name, nvl(f.name, 'null'), nvl(f.file#, 0), nvl(f.bytes, 0), nvl(f.status, 'null') from v$tablespace ts, v$datafile f where ts.ts#= f.ts# union all select ts.name name, nvl(f.name, 'null'), nvl(f.file#, 0), nvl(f.bytes, 0), nvl(f.status, 'null') from v$tablespace ts, v$tempfile f where ts.ts#= f.ts#) order by name;