This is not a real database snapshot but set of demo screenshots. Please allow some inaccuracy in numbers and dates.

[02/17/12 05:37:27pm]    Database: rdemo16    Instance: #2 rdemo162    rrac16b.obzora.prv    10.2.0.4.0    Uptime: 10 days 18 hours 20 minutes

Latches Statistic




<-prev next->     Total Latches: 394
## Latch# Level# Name Gets Misses % Gets Sleeps Immediate
Gets
Immediate
Misses
Spin
Gets
Wait Time, ms
1 0 8 event range base latch 254 0 100.000 0 0 0 0 0
2 1 8 post/wait queue 5744127 6354 99.889 39 4215859 7259 6319 5
3 2 0 hot latch diags 0 0 0.000 0 0 0 0 0
4 3 1 process allocation 10839343 50754 99.532 60822 1771743 442 1592 701368
5 4 5 session allocation 422606943 2918271 99.309 850097 0 0 2189009 4514621
6 5 0 session switching 18906 0 100.000 0 0 0 0 0
7 6 0 process group creation 3543491 706 99.980 13 0 0 694 16
8 7 1 session idle bit 2451903255 312857 99.987 2496 0 0 310652 2716
9 8 7 client/application info 14963895 2 100.000 0 0 0 2 0
10 9 8 longop free list parent 522581 0 100.000 0 65944650 23 0 0
11 10 8 ksuosstats global area 61917 0 100.000 0 0 0 0 0
12 11 8 ksupkttest latch 0 0 0.000 0 0 0 0 0
13 12 0 cached attr list 0 0 0.000 0 0 0 0 0
14 13 5 object stats modification 1054936 5889 99.442 1118 8 0 4846 2648
15 14 2 Testing 0 0 0.000 0 0 0 0 0
16 15 6 parameter table allocation management 2963728 350252 88.182 185365 0 0 183710 1466898
17 16 0 event group latch 1772185 0 100.000 0 0 0 0 0
18 17 8 messages 65428855 32846 99.950 558 0 0 32330 359
19 18 5 enqueues 693671578 9577197 98.619 82366 0 0 9497331 145145
20 19 4 enqueue hash chains 771384240 4558554 99.409 57822 2504548 674 4502092 88611
21 20 0 instance enqueue 1 0 100.000 0 0 0 0 0
22 21 4 trace latch 1495 0 100.000 0 0 0 0 0
23 22 6 FOB s.o list latch 5578282 7043 99.874 749 0 0 6336 101875
24 23 6 FIB s.o chain latch 545334 0 100.000 0 0 0 0 0
25 24 6 SGA IO buffer pool latch 120488 13 99.989 0 123212 99 13 0


[an error occurred while processing this directive]