SQL> exec runStats_pkg.rs_middle; PL/SQL procedure successfully completed. SQL> SELECT o.owner, o.object_type, COUNT(*) 2 FROM all_my_objects o 3 GROUP BY CUBE (o.object_type, o.owner); OWNER OBJECT_TYPE COUNT(*) ------------------------------ ------------------- ---------- 327 rows selected. SQL> exec runStats_pkg.rs_stop; Run1 ran in 15675 hsecs Run2 ran in 5486 hsecs run 1 ran in 285.73% of the time Name Run1 Run2 Diff LATCH.dml lock allocation 2 1 -1 LATCH.compile environment latc 3 2 -1 LATCH.file cache latch 2 1 -1 LATCH.deferred cleanup latch 2 1 -1 LATCH.dictionary lookup 0 1 1 LATCH.job_queue_processes free 0 1 1 LATCH.cp sga latch 2 1 -1 STAT...session cursor cache co 1 0 -1 LATCH.resmgr:actses change gro 3 2 -1 STAT...parse time cpu 3 2 -1 STAT...parse count (total) 14 15 1 STAT...execute count 14 15 1 LATCH.Real-time plan statistic 19 18 -1 LATCH.threshold alerts latch 2 1 -1 LATCH.ncodef allocation latch 2 1 -1 LATCH.session switching 3 2 -1 LATCH.corrupted undo seg lock 0 1 1 LATCH.process group creation 3 1 -2 LATCH.process allocation 3 1 -2 LATCH.post/wait queue 6 8 2 STAT...sorts (memory) 0 2 2 STAT...opened cursors cumulati 14 12 -2 LATCH.FAL subheap alocation 3 1 -2 LATCH.temporary table state ob 0 2 2 LATCH.job_queue_processes para 4 2 -2 LATCH.user lock 5 3 -2 LATCH.FAL request queue 3 1 -2 LATCH.JS slv state obj latch 5 7 2 LATCH.ksz_so allocation latch 3 1 -2 LATCH.OS process: request allo 3 1 -2 LATCH.ksv allocation latch 3 1 -2 LATCH.ksv class latch 3 1 -2 LATCH.resmgr:actses change sta 4 1 -3 STAT...enqueue waits 3 0 -3 STAT...active txn count during 1 4 3 LATCH.sort extent pool 18 21 3 LATCH.dummy allocation 10 6 -4 LATCH.resmgr:free threads list 9 5 -4 LATCH.SQL memory manager latch 6 2 -4 STAT...table scans (direct rea 4 0 -4 LATCH.NLS data objects 4 0 -4 LATCH.session state list latch 9 5 -4 STAT...index scans kdiixs1 0 4 4 STAT...workarea executions - o 8 4 -4 LATCH.kwqbsn:qsga 6 2 -4 LATCH.parameter table manageme 11 7 -4 STAT...session cursor cache hi 6 11 5 LATCH.channel handle pool latc 7 2 -5 LATCH.resmgr group change latc 10 5 -5 LATCH.OS process 10 4 -6 LATCH.pesom_heap_alloc 7 1 -6 LATCH.ksuosstats global area 10 4 -6 STAT...table scans (long table 8 2 -6 LATCH.FOB s.o list latch 18 11 -7 LATCH.sequence cache 9 16 7 LATCH.KTF sga latch 0 8 8 LATCH.KWQS pqueue ctx latch 10 0 -10 LATCH.list of block allocation 16 6 -10 STAT...enqueue conversions 12 0 -12 LATCH.message pool operations 13 1 -12 LATCH.hash table modification 20 7 -13 LATCH.loader state object free 16 2 -14 STAT...enqueue releases 18 4 -14 STAT...enqueue requests 19 4 -15 STAT...pinned buffers inspecte 0 15 15 LATCH.parallel query alloc buf 21 5 -16 LATCH.qmn task queue latch 24 8 -16 LATCH.Shared B-Tree 20 3 -17 STAT...dirty buffers inspected 0 18 18 STAT...consistent changes 56 36 -20 LATCH.commit callback allocati 21 1 -20 STAT...db block changes 69 48 -21 LATCH.resmgr:schema config 32 11 -21 STAT...db block gets 54 32 -22 STAT...db block gets from cach 54 32 -22 LATCH.client/application info 53 27 -26 STAT...recursive calls 53 82 29 LATCH.shared pool sim alloc 35 4 -31 LATCH.KMG MMAN ready and start 52 19 -33 LATCH.OS process allocation 55 20 -35 LATCH.transaction branch alloc 55 19 -36 LATCH.Change Notification Hash 55 19 -36 LATCH.session timer 55 19 -36 LATCH.archive process latch 54 18 -36 STAT...calls to get snapshot s 69 32 -37 STAT...hot buffers moved to he 46 0 -46 LATCH.resmgr:active threads 73 26 -47 LATCH.session idle bit 124 77 -47 STAT...undo change vector size 3,024 2,976 -48 STAT...workarea memory allocat -22 42 64 STAT...prefetched blocks aged 64 0 -64 STAT...CPU used when call star 128 64 -64 STAT...CPU used by this sessio 128 63 -65 LATCH.ASM db client latch 104 33 -71 LATCH.In memory undo latch 73 1 -72 LATCH.space background task la 117 40 -77 LATCH.longop free list parent 86 1 -85 LATCH.kokc descriptor allocati 106 13 -93 LATCH.cache table scan latch 537 651 114 LATCH.peshm 135 1 -134 LATCH.archive control 146 1 -145 STAT...buffer is not pinned co 228 76 -152 STAT...redo size 3,952 3,792 -160 LATCH.kks stats 357 161 -196 LATCH.active service list 335 123 -212 STAT...bytes received via SQL* 1,746 1,515 -231 STAT...parse time elapsed 420 141 -279 LATCH.multiblock read objects 1,176 1,497 321 STAT...physical read total mul 389 41 -348 STAT...physical read IO reques 436 60 -376 STAT...physical read total IO 436 60 -376 STAT...Number of read IOs issu 388 0 -388 LATCH.pesom_free_list 419 1 -418 LATCH.Consistent RBA 482 48 -434 LATCH.lgwr LWN SCN 485 49 -436 LATCH.mostly latch-free SCN 485 49 -436 LATCH.object stats modificatio 603 50 -553 LATCH.channel operations paren 871 275 -596 LATCH.active checkpoint queue 872 134 -738 LATCH.JS queue state obj latch 1,152 396 -756 LATCH.object queue header heap 1,264 169 -1,095 LATCH.pesom_hash_node 1,142 1 -1,141 STAT...free buffer inspected 676 1,863 1,187 LATCH.redo allocation 1,453 147 -1,306 STAT...physical reads cache pr 515 2,128 1,613 STAT...free buffer requested 573 2,193 1,620 STAT...physical reads cache 563 2,188 1,625 STAT...no work - consistent re 4,426 6,091 1,665 STAT...bytes sent via SQL*Net 10,488 8,805 -1,683 LATCH.JOX SGA heap latch 1,983 0 -1,983 LATCH.redo writing 2,402 313 -2,089 LATCH.enqueues 3,308 1,151 -2,157 LATCH.SQL memory manager worka 4,105 1,203 -2,902 LATCH.library cache load lock 3,309 183 -3,126 LATCH.messages 4,336 815 -3,521 LATCH.MinActiveScn Latch 4,810 190 -4,620 STAT...user I/O wait time 7,145 1,703 -5,442 LATCH.checkpoint queue latch 6,956 1,444 -5,512 STAT...consistent gets from ca 233 6,041 5,808 STAT...DB time 7,851 1,809 -6,042 LATCH.cache buffer handles 6,731 148 -6,583 LATCH.transaction allocation 9,569 2,396 -7,173 LATCH.enqueue hash chains 9,226 1,410 -7,816 STAT...Elapsed Time 15,737 5,495 -10,242 STAT...consistent gets from ca 20,174 6,125 -14,049 STAT...table scan blocks gotte 24,308 6,077 -18,231 STAT...consistent gets - exami 19,893 8 -19,885 STAT...cleanout - number of kt 19,893 4 -19,889 STAT...calls to kcmgrs 19,918 29 -19,889 STAT...commit txn count during 19,892 0 -19,892 STAT...cleanouts only - consis 19,892 0 -19,892 STAT...immediate (CR) block cl 19,892 0 -19,892 STAT...physical reads 24,663 2,188 -22,475 STAT...consistent gets direct 24,100 0 -24,100 STAT...physical reads direct 24,100 0 -24,100 LATCH.undo global data 26,623 837 -25,786 LATCH.DML lock allocation 46,810 10,732 -36,078 STAT...consistent gets 44,274 6,125 -38,149 STAT...session logical reads 44,328 6,157 -38,171 LATCH.row cache objects 61,677 10,924 -50,753 LATCH.shared pool simulator 54,251 1,488 -52,763 LATCH.cache buffers lru chain 73,688 20,172 -53,516 STAT...session uga memory max 65,464 0 -65,464 STAT...session uga memory 0 65,464 65,464 STAT...session pga memory 0 65,536 65,536 LATCH.shared pool 74,257 6,400 -67,857 LATCH.object queue header oper 139,769 38,227 -101,542 LATCH.simulator hash latch 175,341 14,943 -160,398 LATCH.simulator lru latch 170,054 9,598 -160,456 LATCH.session allocation 179,379 16,237 -163,142 STAT...session pga memory max 196,608 0 -196,608 STAT...sorts (rows) 0 412,152 412,152 STAT...table scan rows gotten 1,658,664 414,666 -1,243,998 LATCH.cache buffers chains 2,230,107 127,187 -2,102,920 STAT...Effective IO time 71,810,207 0 -71,810,207 STAT...physical read bytes 202,039,296 17,924,096-184,115,200 STAT...physical read total byt 202,039,296 17,924,096-184,115,200 Run1 latches total versus runs -- difference and pct Run1 Run2 Diff Pct 3,302,283 270,450 -3,031,833 1,221.03% PL/SQL procedure successfully completed. SQL> SQL> spool off