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.