Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL> SELECT * FROM v$version;
- BANNER
- --------------------------------------------------------------------------------
- Oracle DATABASE 11g Release 11.2.0.1.0 - 64bit Production
- PL/SQL Release 11.2.0.1.0 - Production
- CORE 11.2.0.1.0 Production
- TNS FOR Linux: Version 11.2.0.1.0 - Production
- NLSRTL Version 11.2.0.1.0 - Production
- 5 ROWS selected.
- SQL> @core_demo_02b.SQL
- PL/SQL PROCEDURE successfully completed.
- SESSION altered.
- PL/SQL PROCEDURE successfully completed.
- TABLE dropped.
- PL/SQL PROCEDURE successfully completed.
- TABLE created.
- INDEX created.
- PL/SQL PROCEDURE successfully completed.
- BLOCK_NUMBER ROWS_PER_BLOCK
- ------------ --------------
- 132 60
- 133 60
- 2 ROWS selected.
- System altered.
- PL/SQL PROCEDURE successfully completed.
- PL/SQL PROCEDURE successfully completed.
- PL/SQL PROCEDURE successfully completed.
- PL/SQL PROCEDURE successfully completed.
- PL/SQL PROCEDURE successfully completed.
- PL/SQL PROCEDURE successfully completed.
- PL/SQL PROCEDURE successfully completed.
- 50 ROWS updated.
- ---------------------------------
- Latch waits:- 22-Apr 20:18:32
- INTERVAL:- 0 seconds
- ---------------------------------
- Latch Gets Misses Sp_Get Sleeps Im_Gets Im_Miss Holding Woken TIME ms
- ----- ---- ------ ------ ------ ------- ------- ------- ----- -------
- post/wait queue 1 0 0 0 0 0 0 0 .0
- test excl. parent l0 1 0 0 0 0 0 0 0 .0
- test excl. parent2 l0 1 0 0 0 0 0 0 0 .0
- SESSION allocation 5 0 0 0 0 0 0 0 .0
- SESSION switching 1 0 0 0 0 0 0 0 .0
- SESSION idle bit 52 0 0 0 0 0 0 0 .0
- client/application info 1 0 0 0 0 0 0 0 .0
- longop free list parent 1 0 0 0 0 0 0 0 .0
- object stats modificatio 1 0 0 0 0 0 0 0 .0
- kss move LOCK 1 0 0 0 0 0 0 0 .0
- enqueues 2 0 0 0 0 0 0 0 .0
- enqueue hash chains 5 0 0 0 0 0 0 0 .0
- ksfv messages 1 0 0 0 0 0 0 0 .0
- msg queue latch 1 0 0 0 0 0 0 0 .0
- done queue latch 1 0 0 0 0 0 0 0 .0
- SESSION queue latch 1 0 0 0 0 0 0 0 .0
- channel handle pool latc 1 0 0 0 0 0 0 0 .0
- channel operations paren 1 0 0 0 0 0 0 0 .0
- message pool operations 1 0 0 0 0 0 0 0 .0
- ksv class latch 1 0 0 0 0 0 0 0 .0
- ksv msg queue latch 1 0 0 0 0 0 0 0 .0
- SECOND spare latch 1 0 0 0 0 0 0 0 .0
- third spare latch 1 0 0 0 0 0 0 0 .0
- fifth spare latch 1 0 0 0 0 0 0 0 .0
- IPC stats buffer allocat 1 0 0 0 0 0 0 0 .0
- granule operation 1 0 0 0 0 0 0 0 .0
- OS process 1 0 0 0 0 0 0 0 .0
- ges process parent latch 1 0 0 0 0 0 0 0 .0
- ges process hash list 1 0 0 0 0 0 0 0 .0
- ges resource TABLE freel 1 0 0 0 0 0 0 0 .0
- ges resource hash list 1 0 0 0 0 0 0 0 .0
- ges resource scan list 1 0 0 0 0 0 0 0 .0
- ges enqueue TABLE freeli 1 0 0 0 0 0 0 0 .0
- KJC message pool free li 1 0 0 0 0 0 0 0 .0
- KJCT flow control latch 1 0 0 0 0 0 0 0 .0
- ges DOMAIN TABLE 1 0 0 0 0 0 0 0 .0
- ges GROUP TABLE 1 0 0 0 0 0 0 0 .0
- gcs resource hash 1 0 0 0 0 0 0 0 .0
- gcs resource freelist 1 0 0 0 0 0 0 0 .0
- gcs resource scan list 1 0 0 0 0 0 0 0 .0
- gcs shadows freelist 1 0 0 0 0 0 0 0 .0
- gcs commit scn state 1 0 0 0 0 0 0 0 .0
- name-service namespace b 1 0 0 0 0 0 0 0 .0
- gcs partitioned TABLE ha 1 0 0 0 0 0 0 0 .0
- gcs pcm hashed VALUE buc 1 0 0 0 0 0 0 0 .0
- recovery DOMAIN hash lis 1 0 0 0 0 0 0 0 .0
- ges VALUE block free lis 1 0 0 0 0 0 0 0 .0
- Testing 1 0 0 0 0 0 0 0 .0
- heartbeat CHECK 1 0 0 0 0 0 0 0 .0
- Memory Management Latch 1 0 0 0 0 0 0 0 .0
- cache buffers lru chain 1 0 0 0 0 0 0 0 .0
- buffer pool 1 0 0 0 0 0 0 0 .0
- checkpoint queue latch 1 0 0 0 2 0 0 0 .0
- cache buffers chains 267 0 0 0 0 0 0 0 .0
- tablespace KEY chain 1 0 0 0 0 0 0 0 .0
- simulator lru latch 1 0 0 0 1 0 0 0 .0
- simulator hash latch 2 0 0 0 0 0 0 0 .0
- sim partition latch 1 0 0 0 0 0 0 0 .0
- object queue header oper 4 0 0 0 0 0 0 0 .0
- object queue header heap 1 0 0 0 0 0 0 0 .0
- redo copy 1 0 0 0 50 0 0 0 .0
- redo allocation 51 0 0 0 0 0 0 0 .0
- gc element 1 0 0 0 0 0 0 0 .0
- logminer WORK area 1 0 0 0 0 0 0 0 .0
- logminer context allocat 1 0 0 0 0 0 0 0 .0
- logical standby cache 1 0 0 0 0 0 0 0 .0
- mapped buffers lru chain 1 0 0 0 0 0 0 0 .0
- LOCK DBA buffer during m 1 0 0 0 0 0 0 0 .0
- flashback copy 1 0 0 0 0 0 0 0 .0
- cvmap freelist LOCK 1 0 0 0 0 0 0 0 .0
- io pool granule metadata 1 0 0 0 0 0 0 0 .0
- DML LOCK allocation 2 0 0 0 0 0 0 0 .0
- TRANSACTION allocation 1 0 0 0 0 0 0 0 .0
- dummy allocation 1 0 0 0 0 0 0 0 .0
- undo global DATA 3 0 0 0 0 0 0 0 .0
- intra txn parallel recov 1 0 0 0 0 0 0 0 .0
- IN memory undo latch 1 0 0 0 0 0 0 0 .0
- CHANGE notification clie 1 0 0 0 0 0 0 0 .0
- lob segment hash TABLE l 1 0 0 0 0 0 0 0 .0
- lob segment query latch 1 0 0 0 0 0 0 0 .0
- lob segment dispenser la 1 0 0 0 0 0 0 0 .0
- File State Object Pool P 1 0 0 0 0 0 0 0 .0
- WRITE State Object Pool 1 0 0 0 0 0 0 0 .0
- kdlx hb parent latch 1 0 0 0 0 0 0 0 .0
- Locator state objects po 1 0 0 0 0 0 0 0 .0
- ROW cache objects 235 0 0 0 0 0 0 0 .0
- kks stats 8 0 0 0 0 0 0 0 .0
- global tx hash mapping 1 0 0 0 0 0 0 0 .0
- k2q LOCK allocation 1 0 0 0 0 0 0 0 .0
- shared pool 95 0 0 0 0 0 0 0 .0
- Token Manager 1 0 0 0 0 0 0 0 .0
- cas latch 1 0 0 0 0 0 0 0 .0
- rm cas latch 1 0 0 0 0 0 0 0 .0
- resmgr:actses CHANGE sta 1 0 0 0 0 0 0 0 .0
- resmgr:actses CHANGE gro 1 0 0 0 0 0 0 0 .0
- resmgr:SESSION queuing 1 0 0 0 0 0 0 0 .0
- resmgr:plan CPU method 1 0 0 0 0 0 0 0 .0
- resmgr:resource GROUP CP 1 0 0 0 0 0 0 0 .0
- QMT 1 0 0 0 0 0 0 0 .0
- shared pool simulator 5 0 0 0 0 0 0 0 .0
- shared pool sim alloc 1 0 0 0 0 0 0 0 .0
- Streams Generic 1 0 0 0 0 0 0 0 .0
- Shared B-Tree 1 0 0 0 0 0 0 0 .0
- Memory Queue 1 0 0 0 0 0 0 0 .0
- Memory Queue Subscriber 1 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 1 0 0 0 0 0 0 0 .0
- pesom_hash_node 1 0 0 0 0 0 0 0 .0
- pesom_free_list 1 0 0 0 0 0 0 0 .0
- peshm 1 0 0 0 0 0 0 0 .0
- Mutex 1 0 0 0 0 0 0 0 .0
- Mutex Stats 1 0 0 0 0 0 0 0 .0
- KGNFS-NFS:SHM STRUCTURE 1 0 0 0 0 0 0 0 .0
- KGNFS-NFS:SVR LIST 1 0 0 0 0 0 0 0 .0
- SGA heap locks 1 0 0 0 0 0 0 0 .0
- SGA pool locks 1 0 0 0 0 0 0 0 .0
- SGA bucket locks 1 0 0 0 0 0 0 0 .0
- SGA BLOB parent 1 0 0 0 0 0 0 0 .0
- kgb parent 1 0 0 0 0 0 0 0 .0
- Event GROUP Locks 1 0 0 0 0 0 0 0 .0
- virtual circuit buffers 1 0 0 0 0 0 0 0 .0
- virtual circuit queues 1 0 0 0 0 0 0 0 .0
- virtual circuit holder 1 0 0 0 0 0 0 0 .0
- cp server hash latch 1 0 0 0 0 0 0 0 .0
- cp pool latch 1 0 0 0 0 0 0 0 .0
- cp cmon/server latch 1 0 0 0 0 0 0 0 .0
- job workq parent latch 1 0 0 0 0 0 0 0 .0
- query server freelists 1 0 0 0 0 0 0 0 .0
- process queue 1 0 0 0 0 0 0 0 .0
- process queue reference 1 0 0 0 0 0 0 0 .0
- parallel query stats 1 0 0 0 0 0 0 0 .0
- business card 1 0 0 0 0 0 0 0 .0
- queuing LOAD statistics 1 0 0 0 0 0 0 0 .0
- parallel query alloc buf 1 0 0 0 0 0 0 0 .0
- PX hash array latch 1 0 0 0 0 0 0 0 .0
- hash TABLE modification 1 0 0 0 0 0 0 0 .0
- hash TABLE COLUMN usage 0 0 0 0 4 0 0 0 .0
- SQL memory manager worka 3 0 0 0 0 0 0 0 .0
- AQ deq hash TABLE latch 1 0 0 0 0 0 0 0 .0
- XDB unused SESSION pool 1 0 0 0 0 0 0 0 .0
- XDB used SESSION pool 1 0 0 0 0 0 0 0 .0
- XDB NFS Security Latch 1 0 0 0 0 0 0 0 .0
- KFC Hash Latch 1 0 0 0 0 0 0 0 .0
- KFC FX Hash Latch 1 0 0 0 0 0 0 0 .0
- ASM map operation hash t 1 0 0 0 0 0 0 0 .0
- Lsod array latch 1 0 0 0 0 0 0 0 .0
- KFCL LE Freelist 1 0 0 0 0 0 0 0 .0
- WCR: sync 1 0 0 0 0 0 0 0 .0
- JS slv state obj latch 1 0 0 0 0 0 0 0 .0
- JS queue access latch 1 0 0 0 0 0 0 0 .0
- JS Sh mem access 1 0 0 0 0 0 0 0 .0
- PL/SQL warning settings 15 0 0 0 0 0 0 0 .0
- PL/SQL PROCEDURE successfully completed.
- ---------------------------------
- System stats:- 22-Apr 20:18:32
- INTERVAL:- 0 seconds
- ---------------------------------
- Name VALUE
- ---- -----
- opened cursors cumulative 32
- USER calls 37
- recursive calls 48
- recursive cpu usage 3
- SESSION logical reads 57
- CPU used WHEN CALL started 6
- CPU used BY this SESSION 5
- DB TIME 4
- non-idle wait COUNT 34
- SESSION uga memory 720,296
- SESSION pga memory 131,072
- enqueue requests 3
- enqueue releases 1
- db block gets 53
- db block gets FROM cache 53
- consistent gets 4
- consistent gets FROM cache 4
- consistent gets FROM cache (fastpath) 1
- consistent gets - examination 1
- db block changes 101
- shared hash latch upgrades - no wait 2
- calls TO GET snapshot scn: kcmgss 14
- redo entries 50
- redo SIZE 14,612
- undo CHANGE vector SIZE 6,036
- no WORK - consistent READ gets 1
- INDEX scans kdiixs1 3
- heap block compress 6
- HSC Heap Segment Block Changes 50
- SESSION cursor cache hits 17
- cursor authentications 2
- buffer IS NOT pinned COUNT 3
- workarea executions - optimal 14
- parse TIME cpu 1
- parse COUNT (total) 25
- parse COUNT (hard) 1
- EXECUTE COUNT 39
- bytes sent via SQL*Net TO client 27,563
- bytes received via SQL*Net FROM client 7,709
- SQL*Net roundtrips TO/FROM client 27
- sorts (memory) 13
- sorts (ROWS) 1,188
- PL/SQL PROCEDURE successfully completed.
- ---------------------------------
- SESSION stats - 22-Apr 20:18:32
- INTERVAL:- 0 seconds
- ---------------------------------
- Name VALUE
- ---- -----
- opened cursors cumulative 39
- USER calls 44
- recursive calls 64
- recursive cpu usage 7
- SESSION logical reads 57
- CPU used WHEN CALL started 10
- CPU used BY this SESSION 9
- DB TIME 8
- non-idle wait COUNT 39
- SESSION uga memory 720,296
- SESSION pga memory 131,072
- enqueue requests 3
- enqueue releases 1
- db block gets 53
- db block gets FROM cache 53
- consistent gets 4
- consistent gets FROM cache 4
- consistent gets FROM cache (fastpath) 1
- consistent gets - examination 1
- db block changes 101
- shared hash latch upgrades - no wait 2
- calls TO GET snapshot scn: kcmgss 17
- redo entries 50
- redo SIZE 14,612
- undo CHANGE vector SIZE 6,036
- no WORK - consistent READ gets 1
- INDEX scans kdiixs1 3
- heap block compress 6
- HSC Heap Segment Block Changes 50
- SESSION cursor cache hits 20
- cursor authentications 3
- buffer IS NOT pinned COUNT 3
- workarea executions - optimal 16
- parse TIME cpu 1
- parse COUNT (total) 31
- parse COUNT (hard) 1
- EXECUTE COUNT 47
- bytes sent via SQL*Net TO client 31,923
- bytes received via SQL*Net FROM client 9,197
- SQL*Net roundtrips TO/FROM client 32
- sorts (memory) 15
- sorts (ROWS) 1,190
- PL/SQL PROCEDURE successfully completed.
- Commit complete.
- PL/SQL PROCEDURE successfully completed.
- ---------------------------------
- Latch waits:- 22-Apr 20:18:33
- INTERVAL:- 0 seconds
- ---------------------------------
- Latch Gets Misses Sp_Get Sleeps Im_Gets Im_Miss Holding Woken TIME ms
- ----- ---- ------ ------ ------ ------- ------- ------- ----- -------
- post/wait queue 3 0 0 0 1 0 0 0 .0
- test excl. parent l0 2 0 0 0 0 0 0 0 .0
- test excl. parent2 l0 2 0 0 0 0 0 0 0 .0
- SESSION allocation 10 0 0 0 0 0 0 0 .0
- SESSION switching 2 0 0 0 0 0 0 0 .0
- SESSION idle bit 114 0 0 0 0 0 0 0 .0
- client/application info 2 0 0 0 0 0 0 0 .0
- longop free list parent 2 0 0 0 0 0 0 0 .0
- object stats modificatio 1 0 0 0 0 0 0 0 .0
- kss move LOCK 2 0 0 0 0 0 0 0 .0
- messages 3 0 0 0 0 0 0 0 .0
- enqueues 2 0 0 0 0 0 0 0 .0
- enqueue hash chains 8 0 0 0 0 0 0 0 .0
- ksfv messages 2 0 0 0 0 0 0 0 .0
- msg queue latch 2 0 0 0 0 0 0 0 .0
- done queue latch 2 0 0 0 0 0 0 0 .0
- SESSION queue latch 2 0 0 0 0 0 0 0 .0
- channel handle pool latc 2 0 0 0 0 0 0 0 .0
- channel operations paren 2 0 0 0 0 0 0 0 .0
- message pool operations 2 0 0 0 0 0 0 0 .0
- ksv class latch 2 0 0 0 0 0 0 0 .0
- ksv msg queue latch 2 0 0 0 0 0 0 0 .0
- SECOND spare latch 2 0 0 0 0 0 0 0 .0
- third spare latch 2 0 0 0 0 0 0 0 .0
- fifth spare latch 2 0 0 0 0 0 0 0 .0
- IPC stats buffer allocat 2 0 0 0 0 0 0 0 .0
- granule operation 2 0 0 0 0 0 0 0 .0
- OS process 2 0 0 0 0 0 0 0 .0
- ges process parent latch 2 0 0 0 0 0 0 0 .0
- ges process hash list 2 0 0 0 0 0 0 0 .0
- ges resource TABLE freel 2 0 0 0 0 0 0 0 .0
- ges resource hash list 2 0 0 0 0 0 0 0 .0
- ges resource scan list 2 0 0 0 0 0 0 0 .0
- ges enqueue TABLE freeli 2 0 0 0 0 0 0 0 .0
- KJC message pool free li 2 0 0 0 0 0 0 0 .0
- KJCT flow control latch 2 0 0 0 0 0 0 0 .0
- ges DOMAIN TABLE 2 0 0 0 0 0 0 0 .0
- ges GROUP TABLE 2 0 0 0 0 0 0 0 .0
- gcs resource hash 2 0 0 0 0 0 0 0 .0
- gcs resource freelist 2 0 0 0 0 0 0 0 .0
- gcs resource scan list 2 0 0 0 0 0 0 0 .0
- gcs shadows freelist 2 0 0 0 0 0 0 0 .0
- gcs commit scn state 2 0 0 0 0 0 0 0 .0
- name-service namespace b 2 0 0 0 0 0 0 0 .0
- gcs partitioned TABLE ha 2 0 0 0 0 0 0 0 .0
- gcs pcm hashed VALUE buc 2 0 0 0 0 0 0 0 .0
- recovery DOMAIN hash lis 2 0 0 0 0 0 0 0 .0
- ges VALUE block free lis 2 0 0 0 0 0 0 0 .0
- Testing 2 0 0 0 0 0 0 0 .0
- heartbeat CHECK 2 0 0 0 0 0 0 0 .0
- Memory Management Latch 2 0 0 0 0 0 0 0 .0
- mostly latch-free SCN 1 0 0 0 0 0 0 0 .0
- lgwr LWN SCN 1 0 0 0 0 0 0 0 .0
- Consistent RBA 1 0 0 0 0 0 0 0 .0
- cache buffers lru chain 2 0 0 0 0 0 0 0 .0
- buffer pool 2 0 0 0 0 0 0 0 .0
- checkpoint queue latch 2 0 0 0 2 0 0 0 .0
- cache buffers chains 273 0 0 0 0 0 0 0 .0
- tablespace KEY chain 2 0 0 0 0 0 0 0 .0
- simulator lru latch 2 0 0 0 1 0 0 0 .0
- simulator hash latch 3 0 0 0 0 0 0 0 .0
- sim partition latch 2 0 0 0 0 0 0 0 .0
- object queue header oper 5 0 0 0 0 0 0 0 .0
- object queue header heap 2 0 0 0 0 0 0 0 .0
- redo writing 3 0 0 0 0 0 0 0 .0
- redo copy 2 0 0 0 51 0 0 0 .0
- redo allocation 55 0 0 0 0 0 0 0 .0
- gc element 2 0 0 0 0 0 0 0 .0
- logminer WORK area 2 0 0 0 0 0 0 0 .0
- logminer context allocat 2 0 0 0 0 0 0 0 .0
- logical standby cache 2 0 0 0 0 0 0 0 .0
- mapped buffers lru chain 2 0 0 0 0 0 0 0 .0
- LOCK DBA buffer during m 2 0 0 0 0 0 0 0 .0
- flashback copy 2 0 0 0 0 0 0 0 .0
- cvmap freelist LOCK 2 0 0 0 0 0 0 0 .0
- io pool granule metadata 2 0 0 0 0 0 0 0 .0
- DML LOCK allocation 4 0 0 0 0 0 0 0 .0
- TRANSACTION allocation 2 0 0 0 0 0 0 0 .0
- dummy allocation 2 0 0 0 0 0 0 0 .0
- undo global DATA 5 0 0 0 0 0 0 0 .0
- intra txn parallel recov 2 0 0 0 0 0 0 0 .0
- IN memory undo latch 2 0 0 0 0 0 0 0 .0
- KTF sga latch 0 0 0 0 1 0 0 0 .0
- CHANGE notification clie 2 0 0 0 0 0 0 0 .0
- lob segment hash TABLE l 2 0 0 0 0 0 0 0 .0
- lob segment query latch 2 0 0 0 0 0 0 0 .0
- lob segment dispenser la 2 0 0 0 0 0 0 0 .0
- File State Object Pool P 2 0 0 0 0 0 0 0 .0
- WRITE State Object Pool 2 0 0 0 0 0 0 0 .0
- kdlx hb parent latch 2 0 0 0 0 0 0 0 .0
- Locator state objects po 2 0 0 0 0 0 0 0 .0
- ROW cache objects 470 0 0 0 0 0 0 0 .0
- kks stats 9 0 0 0 0 0 0 0 .0
- global tx hash mapping 2 0 0 0 0 0 0 0 .0
- k2q LOCK allocation 2 0 0 0 0 0 0 0 .0
- shared pool 112 0 0 0 0 0 0 0 .0
- Token Manager 2 0 0 0 0 0 0 0 .0
- cas latch 2 0 0 0 0 0 0 0 .0
- rm cas latch 2 0 0 0 0 0 0 0 .0
- resmgr:actses CHANGE sta 2 0 0 0 0 0 0 0 .0
- resmgr:actses CHANGE gro 2 0 0 0 0 0 0 0 .0
- resmgr:SESSION queuing 2 0 0 0 0 0 0 0 .0
- resmgr:plan CPU method 2 0 0 0 0 0 0 0 .0
- resmgr:resource GROUP CP 2 0 0 0 0 0 0 0 .0
- QMT 2 0 0 0 0 0 0 0 .0
- shared pool simulator 6 0 0 0 0 0 0 0 .0
- shared pool sim alloc 2 0 0 0 0 0 0 0 .0
- Streams Generic 2 0 0 0 0 0 0 0 .0
- Shared B-Tree 2 0 0 0 0 0 0 0 .0
- Memory Queue 2 0 0 0 0 0 0 0 .0
- Memory Queue Subscriber 2 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0
- Memory Queue Message Sub 2 0 0 0 0 0 0 0 .0
- pesom_hash_node 2 0 0 0 0 0 0 0 .0
- pesom_free_list 2 0 0 0 0 0 0 0 .0
- peshm 2 0 0 0 0 0 0 0 .0
- Mutex 2 0 0 0 0 0 0 0 .0
- Mutex Stats 2 0 0 0 0 0 0 0 .0
- KGNFS-NFS:SHM STRUCTURE 2 0 0 0 0 0 0 0 .0
- KGNFS-NFS:SVR LIST 2 0 0 0 0 0 0 0 .0
- SGA heap locks 2 0 0 0 0 0 0 0 .0
- SGA pool locks 2 0 0 0 0 0 0 0 .0
- SGA bucket locks 2 0 0 0 0 0 0 0 .0
- SGA BLOB parent 2 0 0 0 0 0 0 0 .0
- kgb parent 2 0 0 0 0 0 0 0 .0
- Event GROUP Locks 2 0 0 0 0 0 0 0 .0
- virtual circuit buffers 2 0 0 0 0 0 0 0 .0
- virtual circuit queues 2 0 0 0 0 0 0 0 .0
- virtual circuit holder 2 0 0 0 0 0 0 0 .0
- cp server hash latch 2 0 0 0 0 0 0 0 .0
- cp pool latch 2 0 0 0 0 0 0 0 .0
- cp cmon/server latch 2 0 0 0 0 0 0 0 .0
- job workq parent latch 2 0 0 0 0 0 0 0 .0
- query server freelists 2 0 0 0 0 0 0 0 .0
- process queue 2 0 0 0 0 0 0 0 .0
- process queue reference 2 0 0 0 0 0 0 0 .0
- parallel query stats 2 0 0 0 0 0 0 0 .0
- business card 2 0 0 0 0 0 0 0 .0
- queuing LOAD statistics 2 0 0 0 0 0 0 0 .0
- parallel query alloc buf 2 0 0 0 0 0 0 0 .0
- PX hash array latch 2 0 0 0 0 0 0 0 .0
- hash TABLE modification 1 0 0 0 0 0 0 0 .0
- hash TABLE COLUMN usage 0 0 0 0 4 0 0 0 .0
- SQL memory manager worka 6 0 0 0 0 0 0 0 .0
- AQ deq hash TABLE latch 2 0 0 0 0 0 0 0 .0
- XDB unused SESSION pool 2 0 0 0 0 0 0 0 .0
- XDB used SESSION pool 2 0 0 0 0 0 0 0 .0
- XDB NFS Security Latch 2 0 0 0 0 0 0 0 .0
- KFC Hash Latch 2 0 0 0 0 0 0 0 .0
- KFC FX Hash Latch 2 0 0 0 0 0 0 0 .0
- ASM map operation hash t 2 0 0 0 0 0 0 0 .0
- Lsod array latch 2 0 0 0 0 0 0 0 .0
- KFCL LE Freelist 2 0 0 0 0 0 0 0 .0
- WCR: sync 2 0 0 0 0 0 0 0 .0
- JS slv state obj latch 2 0 0 0 0 0 0 0 .0
- JS queue access latch 2 0 0 0 0 0 0 0 .0
- JS Sh mem access 2 0 0 0 0 0 0 0 .0
- PL/SQL warning settings 28 0 0 0 0 0 0 0 .0
- PL/SQL PROCEDURE successfully completed.
- ---------------------------------
- System stats:- 22-Apr 20:18:33
- INTERVAL:- 0 seconds
- ---------------------------------
- Name VALUE
- ---- -----
- opened cursors cumulative 52
- USER commits 1
- USER calls 67
- recursive calls 73
- recursive cpu usage 8
- SESSION logical reads 58
- CPU used WHEN CALL started 11
- CPU used BY this SESSION 10
- DB TIME 8
- non-idle wait COUNT 69
- SESSION uga memory 720,296
- messages sent 1
- messages received 1
- background timeouts 1
- SESSION pga memory 131,072
- enqueue requests 3
- enqueue releases 3
- physical WRITE total IO requests 1
- physical WRITE total bytes 15,360
- cell physical IO interconnect bytes 15,360
- db block gets 54
- db block gets FROM cache 54
- consistent gets 4
- consistent gets FROM cache 4
- consistent gets FROM cache (fastpath) 1
- consistent gets - examination 1
- db block changes 102
- redo synch writes 1
- commit cleanouts 2
- commit cleanouts successfully completed 2
- shared hash latch upgrades - no wait 2
- calls TO kcmgas 1
- calls TO GET snapshot scn: kcmgss 20
- redo entries 51
- redo SIZE 14,776
- redo wastage 44
- redo writes 1
- redo blocks written 30
- undo CHANGE vector SIZE 6,036
- no WORK - consistent READ gets 1
- INDEX scans kdiixs1 3
- heap block compress 6
- HSC Heap Segment Block Changes 50
- SESSION cursor cache hits 35
- cursor authentications 2
- buffer IS NOT pinned COUNT 3
- workarea executions - optimal 19
- parse TIME cpu 1
- parse COUNT (total) 39
- parse COUNT (hard) 1
- EXECUTE COUNT 67
- bytes sent via SQL*Net TO client 62,486
- bytes received via SQL*Net FROM client 13,186
- SQL*Net roundtrips TO/FROM client 50
- sorts (memory) 17
- sorts (ROWS) 1,780
- PL/SQL PROCEDURE successfully completed.
- ---------------------------------
- SESSION stats - 22-Apr 20:18:33
- INTERVAL:- 0 seconds
- ---------------------------------
- Name VALUE
- ---- -----
- opened cursors cumulative 59
- USER commits 1
- USER calls 75
- recursive calls 89
- recursive cpu usage 11
- SESSION logical reads 58
- CPU used WHEN CALL started 15
- CPU used BY this SESSION 14
- DB TIME 12
- non-idle wait COUNT 74
- SESSION uga memory 720,296
- messages sent 1
- SESSION pga memory 131,072
- enqueue requests 3
- enqueue releases 3
- db block gets 54
- db block gets FROM cache 54
- consistent gets 4
- consistent gets FROM cache 4
- consistent gets FROM cache (fastpath) 1
- consistent gets - examination 1
- db block changes 102
- redo synch writes 1
- commit cleanouts 2
- commit cleanouts successfully completed 2
- shared hash latch upgrades - no wait 2
- calls TO kcmgas 1
- calls TO GET snapshot scn: kcmgss 23
- redo entries 51
- redo SIZE 14,776
- undo CHANGE vector SIZE 6,036
- no WORK - consistent READ gets 1
- INDEX scans kdiixs1 3
- heap block compress 6
- HSC Heap Segment Block Changes 50
- SESSION cursor cache hits 39
- cursor authentications 3
- buffer IS NOT pinned COUNT 3
- workarea executions - optimal 21
- parse TIME cpu 1
- parse COUNT (total) 45
- parse COUNT (hard) 1
- EXECUTE COUNT 76
- bytes sent via SQL*Net TO client 68,109
- bytes received via SQL*Net FROM client 14,717
- SQL*Net roundtrips TO/FROM client 56
- sorts (memory) 19
- sorts (ROWS) 1,782
- PL/SQL PROCEDURE successfully completed.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement