awr里模拟逻辑取数
5墨值下载
WITH SNAP AS
(SELECT *
FROM (SELECT DBID,
LEAD(SNAP_ID) OVER(PARTITION BY INSTANCE_NUMBER ORDER BY
END_INTERVAL_TIME DESC) BID,
SNAP_ID EID,
ROW_NUMBER() OVER(ORDER BY END_INTERVAL_TIME DESC) N
FROM DBA_HIST_SNAPSHOT
WHERE DBID = (SELECT DBID FROM V$DATABASE))
WHERE N = 1),
AWR AS
(SELECT ROWNUM LINE, OUTPUT
FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_TEXT(L_DBID => (SELECT DBID
FROM SNAP),
L_INST_NUM => (SELECT INSTANCE_NUMBER
FROM V$INSTANCE),
L_BID => (SELECT BID
FROM SNAP),
L_EID => (SELECT EID
FROM SNAP),
L_OPTIONS => 1 + 4 + 8))),
AWR_SECTIONS AS
(SELECT LAST_VALUE(CASE
WHEN REGEXP_REPLACE(OUTPUT, ' *DB/Inst.*$') IN ('',
'Database Summary',
'Database Instances Included In Report',
'Top Event P1/P2/P3 Values',
'Top SQL with Top Events',
'Top SQL with Top Row Sources',
'Top Sessions',
'Top Blocking Sessions',
'Top PL/SQL Procedures',
'Top Events',
'Top DB Objects',
'Activity Over Time',
'Wait Event Histogram Detail (64 msec to 2
sec)',
'Wait Event Histogram Detail (4 sec to 2
min)',
'Wait Event Histogram Detail (4 min to 1
hr)',
'SQL ordered by Elapsed Time',
'SQL ordered by CPU Time',
'SQL ordered by User I/O Wait Time',
'SQL ordered by Gets',
'SQL ordered by Reads',
'SQL ordered by Physical Reads
(UnOptimized)',
'SQL ordered by Optimized Reads',
'SQL ordered by Executions',
'SQL ordered by Parse Calls',
'SQL ordered by Sharable Memory',
'SQL ordered by Version Count',
'SQL ordered by Cluster Wait Time',
'Key Instance Activity Stats',
'Instance Activity Stats',
'IOStat by Function summary',
'IOStat by Filetype summary',
'IOStat by Function/Filetype summary',
'Tablespace IO Stats',
'File IO Stats',
'Checkpoint Activity',
'MTTR Advisory',
'Segments by Logical Reads',
'Segments by Physical Reads',
'Segments by Direct Physical Reads',
'Segments by Physical Read Requests',
'Segments by UnOptimized Reads',
'Segments by Optimized Reads',
'Segments by Physical Write Requests',
'Segments by Physical Writes',
'Segments by Direct Physical Writes',
'Segments by DB Blocks Changes',
'Segments by Table Scans',
'Segments by Row Lock Waits',
'Segments by ITL Waits',
'Segments by Buffer Busy Waits',
'Segments by Global Cache Buffer Busy',
'Segments by CR Blocks Received',
'Segments by Current Blocks Received',
'In-Memory Segments by Scans',
'In-Memory Segments by DB Block Changes',
'In-Memory Segments by Populate CUs',
'In-Memory Segments by Repopulate CUs',
'Interconnect Device Statistics',
'Dynamic Remastering Stats',
'Resource Manager Plan Statistics',
'Resource Manager Consumer Group Statistics',
'Replication System Resource Usage',
'Replication SGA Usage',
'GoldenGate Capture',
'GoldenGate Capture Rate',
'GoldenGate Apply Reader',
'GoldenGate Apply Coordinator',
'GoldenGate Apply Server',
'GoldenGate Apply Coordinator Rate',
'GoldenGate Apply Reader and Server Rate',
'XStream Capture',
'XStream Capture Rate',
'XStream Apply Reader',
'XStream Apply Coordinator',
'XStream Apply Server',
'XStream Apply Coordinator Rate',
'XStream Apply Reader and Server Rate',
'Table Statistics by DML Operations',
'Table Statistics by Conflict Resolutions',
'Replication Large Transaction Statistics',
'Replication Long Running Transaction
of 7
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论