FIXED_TABLE/PERFORMANCE VIEW조회를 위한 사전 작업
CREATE VIEW V_X$KCBSW AS SELECT * FROM X$KCBSW;
CREATE VIEW V_X$KCBWH AS SELECT * FROM X$KCBWH;
GRANT SELECT ON V_X$KCBSW TO PUBLIC;
GRANT SELECT ON V_X$KCBWH TO PUBLIC;
CREATE PUBLIC SYNONYM X$KCBSW FOR SYS.V_X$KCBSW;
CREATE PUBLIC SYNONYM X$KCBWH FOR SYS.V_X$KCBWH;
GRANT SELECT ON V_$SESSTAT TO PUBLIC;
GRANT SELECT ON V_$STATNAME TO PUBLIC;
GRANT SELECT ON V_$SESSION_EVENT TO PUBLIC;
GRANT SELECT ON V_$SESS_TIME_MODEL TO PUBLIC;
GRANT SELECT ON V_$LATCH TO PUBLIC;
GRANT SELECT ON V_$LATCH_MISSES TO PUBLIC;
GRANT SELECT ON V_$ROWCACHE TO PUBLIC;
GRANT SELECT ON V_$MUTEX_SLEEP TO PUBLIC;
GRANT SELECT ON V_$LIBRARYCACHE TO PUBLIC;
GRANT SELECT ON V_$SGA_RESIZE_OPS TO PUBLIC;
GRANT SELECT ON V_$SGA_CURRENT_RESIZE_OPS TO PUBLIC;
GRANT SELECT ON V_$OSSTAT TO PUBLIC;
grant execute on dbms_lock to public;
CREATE GLOBAL TEMPORARY TABLE WOONG.SES_SNAPSHOT
(
SID NUMBER,
SEQ NUMBER,
TYPE VARCHAR2 (20),
NAME VARCHAR2 (200),
VALUE NUMBER
)
ON COMMIT PRESERVE ROWS;
CREATE OR REPLACE PACKAGE WOONG.WOONG_PKG AS
TYPE RPT_LIST_TYPE IS RECORD (TYPE VARCHAR2 (100) ,
NAME VARCHAR2 (200) ,
DIFF VARCHAR2 (4000));
TYPE RPT_LIST IS TABLE OF RPT_LIST_TYPE;
FUNCTION SNAP_REPORT(agsid IN number) RETURN RPT_LIST PIPELINED;
FUNCTION SNAP_REPORT(agsid IN NUMBER, agtime NUMBER, aginterval NUMBER) RETURN RPT_LIST PIPELINED;
PROCEDURE SESSION_SNAP(agsid IN number);
FUNCTION SLEEP(agtime NUMBER) RETURN NUMBER;
END;
/
CREATE OR REPLACE PACKAGE BODY WOONG.WOONG_PKG AS
FUNCTION SLEEP(agtime NUMBER) RETURN NUMBER
IS
BEGIN
DBMS_LOCK.SLEEP(AGTIME);
RETURN 1;
END SLEEP;
FUNCTION SNAP_REPORT(agsid IN NUMBER, agtime NUMBER, aginterval NUMBER) RETURN RPT_LIST PIPELINED
IS
OUT_REC RPT_LIST_TYPE;
BEGIN
FOR I IN 1 .. agtime
LOOP
SESSION_SNAP(agsid);
DBMS_LOCK.SLEEP(aginterval);
END LOOP;
FOR RPT_REC IN ( SELECT SID, TYPE, NAME
, RTRIM(XMLAGG(XMLELEMENT("COL", abs(NEXT_VALUE - PREV_VALUE), '→')
ORDER BY SEQ).EXTRACT('//text()').GETSTRINGVAL(),'→') DIFF
FROM (
SELECT SID, SEQ, TYPE, NAME
, VALUE PREV_VALUE
, LEAD(VALUE) OVER (PARTITION BY SID, TYPE, NAME
ORDER BY SEQ ) NEXT_VALUE
FROM SES_SNAPSHOT
WHERE SID = AGSID
)
WHERE NEXT_VALUE IS NOT NULL
GROUP BY SID, TYPE, NAME
HAVING ABS(SUM(NEXT_VALUE - PREV_VALUE)) > 0
ORDER BY DECODE(TYPE, 'STAT', 1
, 'WAIT', 2
, 'TIME', 3
, 'BUFF GET', 4
, 'LIB GET', 5
, 'LIB INV', 6
, 'ROWCACHE', 7
, 'LATCH', 8
, 'LATCH MISS', 9
, 'MUTEX', 10
, 'SGA RESIZE', 11
, 'OS STAT', 12)
, TO_NUMBER(REPLACE(MAX(NEXT_VALUE - PREV_VALUE ),',','' )) DESC )
LOOP
OUT_REC.TYPE := RPT_REC.TYPE;
OUT_REC.NAME := RPT_REC.NAME;
OUT_REC.DIFF := RPT_REC.DIFF;
PIPE ROW(OUT_REC);
END LOOP;
RETURN;
END SNAP_REPORT;
FUNCTION SNAP_REPORT(agsid IN NUMBER) RETURN RPT_LIST PIPELINED
IS
OUT_REC RPT_LIST_TYPE;
BEGIN
FOR RPT_REC IN ( SELECT SID, TYPE, NAME
, RTRIM(XMLAGG(XMLELEMENT("COL", abs(NEXT_VALUE - PREV_VALUE), '→')
ORDER BY SEQ).EXTRACT('//text()').GETSTRINGVAL(),'→') DIFF
FROM (
SELECT SID, SEQ, TYPE, NAME
, VALUE PREV_VALUE
, LEAD(VALUE) OVER (PARTITION BY SID, TYPE, NAME
ORDER BY SEQ ) NEXT_VALUE
FROM SES_SNAPSHOT
WHERE SID = AGSID
)
WHERE NEXT_VALUE IS NOT NULL
GROUP BY SID, TYPE, NAME
HAVING ABS(SUM(NEXT_VALUE - PREV_VALUE)) > 0
ORDER BY DECODE(TYPE, 'STAT', 1
, 'WAIT', 2
, 'TIME', 3
, 'BUFF GET', 4
, 'LIB GET', 5
, 'LIB INV', 6
, 'ROWCACHE', 7
, 'LATCH', 8
, 'LATCH MISS', 9
, 'MUTEX', 10
, 'SGA RESIZE', 11
, 'OS STAT', 12)
, TO_NUMBER(REPLACE(MAX(NEXT_VALUE - PREV_VALUE ),',','' )) DESC )
LOOP
OUT_REC.TYPE := RPT_REC.TYPE;
OUT_REC.NAME := RPT_REC.NAME;
OUT_REC.DIFF := RPT_REC.DIFF;
PIPE ROW(OUT_REC);
END LOOP;
RETURN;
END SNAP_REPORT;
PROCEDURE SESSION_SNAP(agsid IN number)
AS
PRAGMA AUTONOMOUS_TRANSACTION;
li_seq number;
BEGIN
-- 스냅시퀀스 카운트 (인덱스?? sid + seq)
select nvl(max(seq),0) + 1
into li_seq
from ses_snapshot
where sid = agsid;
-- V$SYSSTAT 혹은 V$SESSTAT 뷰
insert into ses_snapshot
select SID session_id,
li_seq,
'STAT',
n.name,
s.value
from v$sesstat s
, v$statname n
where s.sid = agsid
and s.statistic# = n.statistic#
UNION ALL
-- V$SYSTEM_EVENT 혹은 V$SESSION_EVENT 뷰
select SID session_id,
li_seq,
'WAIT',
event,
time_waited
from v$session_event
where sid = agsid
UNION ALL
-- V$SYS_TIME_MODEL 혹은 V$SESS_TIME_MODEL 뷰
select SID session_id,
li_seq,
'TIME',
stat_name,
value
from v$sess_time_model
where sid = agsid
UNION ALL
-- V$LATCH 뷰 : system level
select agsid session_id ,
li_seq,
'LATCH',
name,
gets
from v$latch
UNION ALL
select agsid session_id ,
li_seq,
'LATCH MISS',
substr(parent_name || '(' || location || ')', 1, 100) ,
sleep_count
from v$latch_misses
UNION ALL
-- V$ROWCACHE 뷰 : system level
select agsid session_id ,
li_seq,
'ROWCACHE',
parameter ,
gets
from v$rowcache
where type = 'PARENT'
-- UNION ALL
-- -- V$MUTEX_SLEEP 혹은 V$MUTEX_SLEEP_HISTORY 뷰 : system level
-- select agsid session_id ,
-- li_seq,
-- 'MUTEX',
-- mutex_type || '.' || location,
-- sleeps
-- from v$mutex_sleep
-- UNION ALL
-- -- Buffer Get 정보 - X$KCBUWHY 뷰와 X$KCBWH 뷰
-- select agsid session_id ,
-- li_seq,
-- 'BUFF GET',
-- kcbwhdes,
-- why0 + why1 + why2
-- from X$KCBSW s, X$KCBWH w -- 10g
-- --X$kcbuwhy s, X$kcbwh w -- llg
-- where s.indx = w.indx
UNION ALL
-- V$LIBRARYCACHE 뷰 : system level
-- library cache(gets)
select agsid session_id ,
li_seq,
'LIB GET',
namespace,
gets
from v$librarycache
UNION ALL
-- library cache(invalidations)
select agsid session_id ,
li_seq,
'LIB INV',
namespace,
invalidations
from v$librarycache
UNION ALL
-- V$SGA_RESIZE_OPS : system level
select agsid session_id ,
li_seq,
'SGA RESIZE',
item,
max(value)
from (select component || '.' || parameter as item,
final_size as value
from v$sga_resize_ops
union all
select component || '.' || parameter as item,
current_size as value
from v$sga_current_resize_ops )
group by item
UNION ALL
-- V$OSSTAT 뷰
select agsid session_id ,
li_seq,
'OS STAT',
stat_name,
value
from v$osstat;
COMMIT;
END SESSION_SNAP;
END WOONG_PKG;
/
SQL> set linesize 150 pagesize 999
SQL>
SQL> EXEC WOONG_PKG.SESSION_SNAP(USERENV('SID'));
PL/SQL 처리가 정상적으로 완료되었습니다.
SQL> select count(*) from dba_objects;
COUNT(*)
----------
72541
SQL> EXEC WOONG_PKG.SESSION_SNAP(USERENV('SID'));
PL/SQL 처리가 정상적으로 완료되었습니다.
SQL> col type format a30
SQL> col name format a50
SQL> col diff format a50
SQL> select * from table(WOONG_PKG.SNAP_REPORT(USERENV('SID')) );
TYPE NAME DIFF
------------------------------ -------------------------------------------------- ---------------------------------------------
STAT session pga memory max 6094848→0→0→2228224
STAT session uga memory max 5391812→388052→0→0
STAT session pga memory -2031616→393216→4718592→0
STAT temp space allocated (bytes) 0→0→1048576→0
STAT session uga memory 65512→0→786144→0
STAT redo size 101324→27592→27144→27440
STAT table scan rows gotten 9835→86913→53300→100077
STAT cell physical IO interconnect bytes 0→32768→98304→0
STAT physical read total bytes 0→32768→98304→0
STAT physical read bytes 0→32768→98304→0
STAT buffer is pinned count 0→81512→15→81512
STAT undo change vector size 57688→19704→19564→19716
STAT sorts (rows) 2532→2409→48641→2408
STAT bytes sent via SQL*Net to client 262→557→14011→557
STAT table fetch by rowid 4→4812→348→4804
STAT index fetch by key 17→4805→79→4804
STAT file io wait time 0→1717→3601→0
STAT session logical reads 1018→2314→1847→2408
STAT consistent gets 320→2002→1515→2099
STAT consistent gets from cache 320→2002→1515→2099
STAT consistent gets from cache (fastpath) 173→1866→1119→1969
STAT no work - consistent read gets 61→1804→1062→1904
STAT bytes received via SQL*Net from client 405→421→1321→421
STAT table scan blocks gotten 85→1020→455→1132
STAT buffer is not pinned count 68→783→1089→761
STAT db block changes 1003→458→460→456
STAT recursive calls 243→87→865→3
STAT db block gets from cache 698→312→332→309
STAT db block gets 698→312→332→309
STAT consistent changes 422→349→355→349
STAT consistent gets - examination 125→131→382→127
STAT redo entries 379→105→103→105
STAT HSC Heap Segment Block Changes 278→104→103→105
STAT calls to kcmgcs 175→176→182→177
STAT DB time 50→83→178→73
STAT calls to get snapshot scn: kcmgss 60→11→173→3
STAT CPU used by this session 45→83→157→72
STAT CPU used when call started 48→83→156→71
STAT recursive cpu usage 44→41→156→38
STAT IMU undo allocation size 52→0→156→0
STAT Heap Segment Array Inserts 105→104→103→105
STAT execute count 67→11→100→4
STAT index scans kdiixs1 43→8→88→3
STAT free buffer requested 81→62→71→57
STAT rows fetched via callback 4→1→78→0
STAT db block gets from cache (fastpath) 74→0→9→0
STAT parse count (total) 65→8→65→2
STAT cleanout - number of ktugct calls 61→8→13→14
STAT commit txn count during cleanout 56→0→0→0
STAT immediate (CR) block cleanout applications 56→0→0→0
STAT cleanouts only - consistent read gets 56→0→0→0
STAT enqueue requests 55→13→25→11
STAT enqueue releases 55→12→25→11
STAT commit cleanouts 50→0→0→0
STAT session cursor cache count 48→-1→1→-2
STAT non-idle wait count 4→9→46→5
STAT opened cursors cumulative 40→10→41→4
STAT commit cleanouts successfully completed 38→0→0→0
STAT user calls 4→5→32→5
STAT session cursor cache hits 12→4→30→3
STAT SQL*Net roundtrips to/from client 2→3→27→3
STAT calls to kcmgas 25→3→2→2
STAT immediate (CURRENT) block cleanout applications 23→0→0→0
STAT workarea executions - optimal 9→10→17→9
STAT switch current to new buffer 15→0→0→0
STAT active txn count during cleanout 5→8→13→14
STAT shared hash latch upgrades - no wait 13→7→1→3
STAT physical reads 0→4→12→0
STAT commit cleanout failures: block lost 12→0→0→0
STAT physical read total IO requests 0→4→12→0
STAT physical reads cache 0→4→12→0
STAT physical read IO requests 0→4→12→0
STAT sorts (memory) 6→3→11→2
STAT table fetch continued row 0→10→1→10
STAT redo subscn max counts 10→3→2→3
STAT parse count (hard) 2→1→8→0
STAT redo ordering marks 6→3→2→2
STAT parse time cpu 0→5→4→0
STAT parse time elapsed 0→5→3→0
STAT table scans (short tables) 4→2→5→2
STAT messages sent 3→0→0→0
STAT sql area purged 0→0→3→0
STAT parse count (failures) 0→0→3→0
STAT change write time 2→0→0→0
STAT opened cursors current 0→0→2→0
STAT cursor authentications 2→1→1→1
STAT user I/O wait time 0→1→0→0
STAT cluster key scans 0→0→1→0
STAT redo synch writes 1→0→0→0
STAT non-idle wait time 1→0→0→0
STAT IMU Flushes 1→0→0→0
STAT cluster key scan block gets 0→0→1→0
STAT user commits 1→0→0→0
STAT deferred (CURRENT) block cleanout applications 1→0→0→0
WAIT SQL*Net message from client 6526→1640→18718→569
WAIT log file sync 1→0→0→0
WAIT db file sequential read 0→0→1→0
TIME DB time 492045→823663→1770868→733076
TIME sql execute elapsed time 476374→775373→1732887→732173
TIME DB CPU 483603→826805→1575610→717605
TIME parse time elapsed 7719→44898→61693→321
TIME hard parse elapsed time 3960→43944→54697→0
TIME PL/SQL compilation elapsed time 2981→0→28430→0
TIME PL/SQL execution elapsed time 1244→305→20654→362
TIME failed parse elapsed time 0→0→19432→0
TIME hard parse (sharing criteria) elapsed time 0→0→1099→0
TIME repeated bind elapsed time 36→6→36→0
LIB GET SQL AREA 176→9→2864→3
LIB GET TABLE/PROCEDURE 235→24→2785→0
LIB GET BODY 54→0→788→0
LIB GET SCHEMA 3→4→286→0
LIB GET TRIGGER 47→0→252→0
LIB GET INDEX 0→0→226→0
LIB GET CLUSTER 0→5→116→0
LIB GET OBJECT ID 3→0→59→0
LIB GET EDITION 1→0→7→0
LIB GET QUEUE 2→0→2→0
LIB GET DBLINK 0→0→1→0
LIB GET SUBSCRIPTION 0→0→1→0
LIB GET RULESET 0→0→0→1
LIB INV SQL AREA 1→0→122→0
LIB INV BODY 1→0→0→0
ROWCACHE dc_objects 142→97→6445→1
ROWCACHE dc_histogram_defs 0→112→5148→0
ROWCACHE dc_segments 0→0→2274→0
ROWCACHE dc_tablespaces 5→93→2146→6
ROWCACHE dc_users 339→96→2015→7
ROWCACHE dc_global_oids 9→0→399→0
ROWCACHE global database name 67→17→185→9
ROWCACHE dc_rollback_segments 0→0→65→0
ROWCACHE dc_awr_control 1→0→55→1
ROWCACHE outstanding_alerts 0→0→5→1
ROWCACHE dc_profiles 1→0→4→0
ROWCACHE dc_sequences 0→0→1→0
LATCH cache buffers chains 13123→5314→876871→5588
LATCH row cache objects 1784→1286→68007→81
LATCH shared pool 659→193→38159→37
LATCH simulator hash latch 174→128→15497→139
LATCH object queue header operation 307→78→11206→74
LATCH enqueue hash chains 1320→347→9927→120
LATCH enqueues 1083→342→5571→104
LATCH messages 931→244→5237→93
LATCH checkpoint queue latch 819→217→4572→81
LATCH SQL memory manager workarea list latch 1418→417→4372→149
LATCH undo global data 153→11→3851→23
LATCH cache buffers lru chain 77→1→3466→1
LATCH DML lock allocation 189→1→2623→13
LATCH channel operations parent latch 450→132→2370→54
LATCH redo writing 119→22→1999→12
LATCH shared pool simulator 20→5→1924→9
LATCH redo allocation 121→22→1750→13
LATCH JS queue state obj latch 468→144→1404→36
LATCH object queue header heap 55→13→1023→5
LATCH call allocation 17→4→919→2
LATCH kks stats 3→3→819→1
LATCH active checkpoint queue latch 27→6→766→2
LATCH kokc descriptor allocation latch 4→0→716→0
LATCH multiblock read objects 0→0→646→0
LATCH object stats modification 5→0→601→0
LATCH In memory undo latch 55→9→562→8
LATCH mostly latch-free SCN 33→6→548→3
LATCH lgwr LWN SCN 33→6→546→3
LATCH cache buffer handles 0→0→508→0
LATCH Consistent RBA 16→1→497→2
LATCH active service list 139→40→431→10
LATCH transaction allocation 5→1→390→8
LATCH ASM db client latch 50→15→309→5
LATCH PL/SQL warning settings 41→1→262→1
LATCH message pool operations parent latch 1→1→235→1
LATCH file cache latch 0→0→222→0
LATCH session idle bit 72→18→206→11
LATCH SGA IO buffer pool latch 0→0→154→0
LATCH cache table scan latch 0→0→150→0
LATCH space background task latch 48→11→139→4
LATCH tablespace key chain 1→1→134→1
LATCH OS process allocation 33→8→117→2
LATCH simulator lru latch 15→1→104→1
LATCH session allocation 24→8→97→1
LATCH list of block allocation 8→2→94→3
LATCH client/application info 26→1→84→1
LATCH OS process 19→7→82→1
LATCH dml lock allocation 1→0→81→0
LATCH session timer 22→5→67→2
LATCH KMG MMAN ready and startup request latch 21→6→63→2
LATCH Change Notification Hash table latch 22→6→62→3
LATCH hash table modification latch 0→0→58→0
LATCH session switching 12→11→49→1
LATCH job_queue_processes parameter latch 15→4→46→1
LATCH session state list latch 6→0→41→0
LATCH loader state object freelist 0→0→40→0
LATCH Shared B-Tree 3→2→38→3
LATCH FOB s.o list latch 2→1→36→0
LATCH qmn task queue latch 8→4→28→0
LATCH resmgr:active threads 7→3→27→1
LATCH process allocation 6→2→27→0
LATCH dummy allocation 7→3→27→1
LATCH parameter table management 6→2→26→0
LATCH resmgr:free threads list 6→2→26→0
LATCH parallel query alloc buffer 9→5→25→1
LATCH channel handle pool latch 5→3→25→1
LATCH shared pool sim alloc 1→1→21→1
LATCH resmgr group change latch 6→0→20→0
LATCH sequence cache 3→0→20→0
LATCH ksz_so allocation latch 4→2→18→0
LATCH OS process: request allocation 4→2→18→0
LATCH process group creation 4→2→18→0
LATCH ksv allocation latch 1→0→15→0
LATCH ksuosstats global area 8→4→15→4
LATCH JS slv state obj latch 15→-246→13→1
LATCH compile environment latch 3→0→13→0
LATCH threshold alerts latch 2→0→13→2
LATCH ksv class latch 1→1→13→1
LATCH post/wait queue 5→1→10→1
LATCH KWQS pqueue ctx latch 0→0→10→1
LATCH Event Group Locks 3→1→10→1
LATCH parameter list 0→0→8→0
LATCH job_queue_processes free list latch 2→0→8→0
LATCH sort extent pool 1→0→8→0
LATCH resmgr:actses change group 2→1→8→1
LATCH kwqbsn:qsga 2→1→7→0
LATCH kss move lock 1→1→7→1
LATCH SQL memory manager latch 2→1→6→0
LATCH job workq parent latch 2→1→5→1
LATCH cp sga latch 1→0→3→0
LATCH ASM network state latch 1→0→3→0
LATCH deferred cleanup latch 1→0→3→0
LATCH ncodef allocation latch 1→0→3→0
LATCH Real-time plan statistics latch 1→0→3→1
LATCH JS Sh mem access 1→1→3→1
LATCH KTF sga latch 0→0→2→0
LATCH ktm global data 0→0→2→0
LATCH rules engine rule set statistics 0→0→0→2
LATCH QMT 1→1→1→1
LATCH Mutex 1→1→1→1
LATCH peshm 1→1→1→1
LATCH Testing 1→1→1→1
LATCH WCR: sync 1→1→1→1
LATCH cas latch 1→1→1→1
LATCH redo copy 1→1→1→1
LATCH gc element 1→1→1→1
LATCH kgb parent 1→1→1→1
LATCH Mutex Stats 1→1→1→1
LATCH buffer pool 1→1→1→1
LATCH Memory Queue 1→1→1→1
LATCH rm cas latch 1→1→1→1
LATCH Token Manager 1→1→1→1
LATCH business card 1→1→1→1
LATCH cp pool latch 1→1→1→1
LATCH ksfv messages 1→1→1→1
LATCH process queue 1→1→1→1
LATCH KFC Hash Latch 1→1→1→1
LATCH SGA heap locks 1→1→1→1
LATCH SGA pool locks 1→1→1→1
LATCH flashback copy 1→1→1→1
LATCH SGA blob parent 1→1→1→1
LATCH Streams Generic 1→1→1→1
LATCH ges group table 1→1→1→1
LATCH heartbeat check 1→1→1→1
LATCH msg queue latch 1→1→1→1
LATCH pesom_free_list 1→1→1→1
LATCH pesom_hash_node 1→1→1→1
LATCH KFCL LE Freelist 1→1→1→1
LATCH Lsod array latch 1→1→1→1
LATCH SGA bucket locks 1→1→1→1
LATCH done queue latch 1→1→1→1
LATCH ges domain table 1→1→1→1
LATCH KFC FX Hash Latch 1→1→1→1
LATCH KWQS pqsubs latch 0→0→0→1
LATCH fifth spare latch 1→1→1→1
LATCH gcs resource hash 1→1→1→1
LATCH granule operation 1→1→1→1
LATCH third spare latch 1→1→1→1
LATCH MinActiveScn Latch 0→0→1→0
LATCH logminer work area 1→1→1→1
LATCH second spare latch 1→1→1→1
LATCH KGNFS-NFS:SVR LIST 1→1→1→1
LATCH PX hash array latch 1→1→1→1
LATCH cvmap freelist lock 1→1→1→1
LATCH k2q lock allocation 1→1→1→1
LATCH ksv msg queue latch 1→1→1→1
LATCH queued dump request 0→0→1→0
LATCH session queue latch 1→1→1→1
LATCH sim partition latch 1→1→1→1
LATCH cp cmon/server latch 1→1→1→1
LATCH cp server hash latch 1→1→1→1
LATCH gcs commit scn state 1→1→1→1
LATCH gcs shadows freelist 1→1→1→1
LATCH kdlx hb parent latch 1→1→1→1
LATCH parallel query stats 1→1→1→1
LATCH resmgr:schema config 1→1→1→1
LATCH test excl. parent l0 1→1→1→1
LATCH JS queue access latch 1→1→1→1
LATCH XDB used session pool 1→1→1→1
LATCH gcs resource freelist 1→1→1→1
LATCH ges process hash list 1→1→1→1
LATCH logical standby cache 1→1→1→1
LATCH test excl. parent2 l0 1→1→1→1
LATCH XDB NFS Security Latch 1→1→1→1
LATCH gcs resource scan list 1→1→1→1
LATCH ges resource hash list 1→1→1→1
LATCH ges resource scan list 1→1→1→1
LATCH global tx hash mapping 1→1→1→1
LATCH query server freelists 1→1→1→1
LATCH resmgr:plan CPU method 1→1→1→1
LATCH resmgr:session queuing 1→1→1→1
LATCH virtual circuit holder 1→1→1→1
LATCH virtual circuit queues 1→1→1→1
LATCH AQ deq hash table latch 1→1→1→1
LATCH KGNFS-NFS:SHM structure 1→1→1→1
LATCH KJCT flow control latch 1→1→1→1
LATCH Memory Management Latch 1→1→1→1
LATCH Memory Queue Subscriber 1→1→1→1
LATCH XDB unused session pool 1→1→1→1
LATCH lob segment query latch 1→1→1→1
LATCH longop free list parent 1→1→1→1
LATCH process queue reference 1→1→1→1
LATCH queuing load statistics 1→1→1→1
LATCH virtual circuit buffers 1→1→1→1
LATCH ges process parent latch 1→1→1→1
LATCH mapped buffers lru chain 1→1→1→1
LATCH ges value block free list 1→1→1→1
LATCH recovery domain hash list 1→1→1→1
LATCH KJC message pool free list 1→1→1→1
LATCH KWQMN job cache list latch 0→0→0→1
LATCH gcs partitioned table hash 1→1→1→1
LATCH ges enqueue table freelist 1→1→1→1
LATCH resmgr:actses change state 1→1→1→1
LATCH ges resource table freelist 1→1→1→1
LATCH intra txn parallel recovery 1→1→1→1
LATCH lob segment dispenser latch 1→1→1→1
LATCH logminer context allocation 1→1→1→1
LATCH ASM map operation hash table 1→1→1→1
LATCH lob segment hash table latch 1→1→1→1
LATCH io pool granule metadata list 1→1→1→1
LATCH name-service namespace bucket 1→1→1→1
LATCH AWR Alerted Metric Element list 0→0→0→1
LATCH gcs pcm hashed value bucket hash 1→1→1→1
LATCH resmgr:resource group CPU method 1→1→1→1
LATCH IPC stats buffer allocation latch 1→1→1→1
LATCH rules engine aggregate statistics 0→0→0→1
LATCH Memory Queue Message Subscriber #1 1→1→1→1
LATCH Memory Queue Message Subscriber #2 1→1→1→1
LATCH Memory Queue Message Subscriber #3 1→1→1→1
LATCH Memory Queue Message Subscriber #4 1→1→1→1
LATCH File State Object Pool Parent Latch 1→1→1→1
LATCH Write State Object Pool Parent Latch 1→1→1→1
LATCH lock DBA buffer during media recovery 1→1→1→1
LATCH change notification client cache latch 1→1→1→1
LATCH Locator state objects pool parent latch 1→1→1→1
LATCH MISS qmn task queue latch(kwqmnmvtsks: delay to ready l 0→0→3→0
ist)
OS STAT VM_IN_BYTES 0→49152→1724416→0
OS STAT IDLE_TIME 11335→2896→30952→1073
OS STAT AVG_IDLE_TIME 5666→1447→15472→536
OS STAT BUSY_TIME 1804→548→6837→210
OS STAT SYS_TIME 1322→389→4610→109
OS STAT AVG_BUSY_TIME 901→274→3417→104
OS STAT AVG_SYS_TIME 659→194→2300→54
OS STAT USER_TIME 482→159→2227→101
OS STAT AVG_USER_TIME 240→79→1109→50
359 개의 행이 선택되었습니다.
위 Script는 순수하게 테스트용으로 구성되어 있습니다.
게시된 Script를 사용하여 발생되는 문제는 책임지지 않습니다.