| Comparing statistics of two queries [message #171882] |
Fri, 12 May 2006 01:04 |
kumarsz
Messages: 180
Registered: March 2005
Location: canada
|
Senior Member |
|
|
Hi All,
Comparing the statistics below can anybody suggest which query is better in performance?
Run1 ran in 1060 hsecs
Run2 ran in 1878 hsecs
run 1 ran in 56.44% of the time
Name Run1 Run2 Diff
LATCH.active checkpoint queue 6 7 1
LATCH.channel handle pool latc 1 2 1
LATCH.enqueues 33 32 -1
LATCH.dummy allocation 3 2 -1
LATCH.job_queue_processes para 1 0 -1
LATCH.lgwr LWN SCN 5 6 1
LATCH.mostly latch-free SCN 5 6 1
LATCH.ncodef allocation latch 1 0 -1
LATCH.process allocation 1 2 1
STAT...redo entries 7 6 -1
STAT...consistent changes 13 12 -1
STAT...CPU used when call star 2 1 -1
STAT...CPU used by this sessio 2 1 -1
LATCH.transaction branch alloc 1 0 -1
LATCH.transaction allocation 3 2 -1
LATCH.spilled msgs queues list 0 1 1
LATCH.sort extent pool 1 0 -1
LATCH.session switching 1 0 -1
LATCH.process group creation 1 2 1
LATCH.kwqit: protect wakeup ti 0 1 1
LATCH.event group latch 1 0 -1
LATCH.multiblock read objects 0 2 2
STAT...db block changes 20 18 -2
LATCH.post/wait queue 2 0 -2
LATCH.session timer 4 6 2
LATCH.Consistent RBA 5 2 -3
LATCH.list of block allocation 3 0 -3
LATCH.channel operations paren 11 14 3
STAT...consistent gets 29 33 4
LATCH.redo writing 21 26 5
STAT...active txn count during 6 11 5
STAT...calls to kcmgcs 6 11 5
STAT...consistent gets - exami 8 13 5
STAT...cleanout - number of kt 6 11 5
LATCH.sequence cache 5 0 -5
LATCH.child cursor hash table 7 0 -7
LATCH.messages 45 53 8
LATCH.FOB s.o list latch 0 9 9
STAT...db block gets 19 28 9
LATCH.loader state object free 12 0 -12
STAT...session logical reads 48 61 13
STAT...bytes received via SQL* 876 834 -42
LATCH.redo allocation 24 99 75
LATCH.undo global data 20 98 78
LATCH.SQL memory manager worka 286 405 119
STAT...redo size 1,924 1,784 -140
LATCH.cache buffers lru chain 192 17 -175
LATCH.session idle bit 149 410 261
LATCH.checkpoint queue latch 597 334 -263
STAT...Elapsed Time 1,061 1,879 818
LATCH.row cache enqueue latch 6,698 66 -6,632
LATCH.row cache objects 6,726 66 -6,660
LATCH.simulator hash latch 9,990 0 -9,990
LATCH.library cache pin alloca 20,062 524 -19,538
LATCH.enqueue hash chains 33,022 196 -32,826
LATCH.dml lock allocation 32,987 112 -32,875
LATCH.session allocation 32,997 85 -32,912
LATCH.shared pool 53,194 460 -52,734
LATCH.library cache pin 66,390 665 -65,725
LATCH.library cache 96,421 1,184 -95,237
LATCH.cache buffers chains 185,737 1,262 -184,475
Run1 latches total versus runs -- difference and pct
Run1 Run2 Diff Pct
545,675 6,162 -539,513 8,855.49%
PL/SQL procedure successfully completed.
Thanks and Regards,
Pratap
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
