<?xml version="1.0" encoding="GBK"?>
<Config Language="default"><DBMoniterSQL>
		<Node Name="查看SGA统计信息" SQL="select * from v$sgastat order by nvl(pool, 1), bytes desc&#xA;"/><Node Name="查看排序情况" SQL="SELECT a.Value memory,&#xA;       b.Value disk,&#xA;       trunc(1 - b.Value / a.Value) * 100 ratio&#xA;  FROM v$sysstat a, v$sysstat b&#xA; WHERE a.NAME = 'sorts (memory)'&#xA;   AND b.NAME = 'sorts (disk)'&#xA;"/><Node Name="查看日志切换情况" SQL="select *&#xA;  from (select * from v$log_history order by first_time desc)&#xA; where rownum &lt; 100&#xA;"/><Node Name="查看锁资源" SQL="select /*+ rule*/ b.SESSION_ID,&#xA;       b.ORACLE_USERNAME,&#xA;       b.OS_USER_NAME,&#xA;       b.PROCESS,&#xA;       b.LOCKED_MODE,&#xA;       a.owner,&#xA;       a.object_name,&#xA;       a.object_id,&#xA;       a.object_type,&#xA;       b.XIDUSN,&#xA;       b.XIDSLOT,&#xA;       b.XIDSQN&#xA;  from all_objects a, v$locked_object b&#xA; where a.object_id = b.object_id&#xA;"/><Node Name="查看库缓存命中率" SQL="select NAMESPACE,&#xA;       GETS,&#xA;       GETHITS,&#xA;       trunc(GETHITRATIO * 100, 2) GETHITRATIO,&#xA;       PINS,&#xA;       PINHITS,&#xA;       trunc(PINHITRATIO * 100, 2) PINHITRATIO,&#xA;       RELOADS,&#xA;       INVALIDATIONS,&#xA;       DLM_LOCK_REQUESTS,&#xA;       DLM_PIN_REQUESTS,&#xA;       DLM_PIN_RELEASES,&#xA;       DLM_INVALIDATION_REQUESTS,&#xA;       DLM_INVALIDATIONS&#xA;  from v$librarycache&#xA;"/><Node Name="查看数据缓存命中率" SQL="select a.*, trunc((1 - phys / (gets + con_gets)) * 100, 2) &quot;HIT RATIO&quot;&#xA;  from (select sum(decode(name, 'physical reads', value, 0)) phys,&#xA;               sum(decode(name, 'db block gets', value, 0)) gets,&#xA;               sum(decode(name, 'consistent gets', value, 0)) con_gets&#xA;          from v$sysstat) a&#xA;"/><Node Name="查看WorkArea情况" SQL="select name, value from v$sysstat where name like '%workarea%'&#xA;"/><Node Name="查看当前会话等待事件" SQL="select * from v$session_wait&#xA;"/><Node Name="查看数据库大小" SQL="select '合计' OWNER, trunc(sum(bytes) / 1024 / 1024) &quot;Size (M)&quot;&#xA;  from dba_segments&#xA;union all&#xA;select owner, trunc(sum(bytes) / 1024 / 1024) &quot;Size (M)&quot;&#xA;  from dba_segments&#xA; group by owner&#xA;"/><Node Name="查询等待事件统计信息" SQL="Select event, total_waits, time_waited, average_wait&#xA;  from v$system_event&#xA; order by total_waits desc&#xA;"/></DBMoniterSQL><MainMenu><Item ID="01" Visable="-1"/><Item ID="02" Visable="-1"/><Item ID="03" Visable="-1"/><Item ID="04" Visable="-1"/><Item ID="10" Visable="-1"/><Item ID="11" Visable="-1"/><Item ID="12" Visable="-1"/><Item ID="20" Visable="-1"/><Item ID="21" Visable="-1"/><Item ID="22" Visable="-1"/><Item ID="23" Visable="-1"/><Item ID="30" Visable="-1"/></MainMenu><PopupMenu><Item ID="30" Visable="-1"/><Item ID="31" Visable="-1"/><Item ID="32" Visable="-1"/><Item ID="34" Visable="-1"/><Item ID="35" Visable="-1"/><Item ID="36" Visable="-1"/><Item ID="37" Visable="-1"/><Item ID="38" Visable="-1"/><Item ID="39" Visable="-1"/><Item ID="40" Visable="-1"/><Item ID="41" Visable="-1"/><Item ID="42" Visable="-1"/></PopupMenu><ExportMenu><Item ID="01" Visable="-1"/></ExportMenu></Config>
