rem ######################################################################################
prompt *******************************************************************************
prompt Database Check Information
prompt *******************************************************************************
ttitle left "DATABASE: "xdbname" (AS OF: "xdate")" skip 2
select name , created , log_mode from v$database
/
prompt
prompt *******************************************************************************
ttitle off
prompt
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 0.0 database map +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt
ttitle left "*** DataBase Map - Control File ***"
column "CONTROL FILE" format A40
select status , name "CONTROL FILE" from v$controlfile
/
ttitle off
ttitle left "*** DataBase Map - RedoLog File ***"
column "Log File" format A40
select f.member "Log File",l.group# ,l.thread# ,l.bytes ,l.status from v$log l, v$logfile f
where l.group# = f.group#
/
ttitle off
ttitle left "*** DataBase Map - Data File ***"
column file_name format A40
select file_name ,tablespace_name,bytes,blocks,status from dba_data_files order by tablespace_name , bytes desc
/
ttitle off
ttitle left "*** DataBase Map - RollBack Seg ***"
SELECT N.NAME "ROLLBACK SEG NAME" , R.EXTENTS , r.rssize , R.OPTSIZE , HWMSIZE ,STATUS
FROM V$ROLLSTAT R,V$rollNAME N
WHERE R.USN = N.USN
/
ttitle off
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
prompt + 1.0 database statistic +
prompt ++++++++++++++++++++++++++++++++++ Item ++++++++++++++++++++++++++++++++++
set heading on
set termout on
TTitle left "*** Database: "xdbname", Database Statistic(As of : "xdate" ) ***" skip 1
column "Statistic Name" format A55
column value format 9,999,999,999,999,990
select n.statistic# , n.name "Statistic Name", s.value
from v$statname n , v$sysstat s
where n.statistic# = s.statistic#
and value > 0
order by value desc
/
上一页 [1] [2] [3] [4] 下一页 没有相关教程
|