arent Latch Statistics DB: PRODSIS  Instance: prodsis  Snaps: 5021 -5131
-> only latches with sleeps are shown
-> ordered by name

                                    Get                           Spin &
Latch Name                     Requests      Misses     Sleeps Sleeps 1->4
------------------------ -------------- ----------- ---------- ------------
Consistent RBA                3,696,675         187         22 165/22/0/0/0
FAL request queue                   439           3          1 2/1/0/0/0
FOB s.o list latch              328,630          32         21 11/21/0/0/0
archive process latch             3,060         225        136 90/134/1/0/0
cache buffer handles        159,117,233      58,770      2,363 56410/2357/3
                                                               /0/0
child cursor hash table      51,065,397      11,485        391 11098/383/4/
                                                               0/0
dml lock allocation          49,141,759      40,101      1,860 38245/1852/4
                                                               /0/0
dummy allocation                262,878         124         53 71/53/0/0/0
enqueue hash chains                 781           1          1 0/1/0/0/0
enqueues                     29,708,847      18,083      2,133 15960/2113/1
                                                               0/0/0
lgwr LWN SCN                  3,697,925       1,695          7 1688/7/0/0/0
library cache                        46           2          1 1/1/0/0/0
list of block allocation        467,016          69          6 63/6/0/0/0
messages                     11,328,733       1,086        182 905/180/1/0/
                                                               0
mostly latch-free SCN         3,729,181      24,871        626 24246/624/1/
                                                               0/0
multiblock read objects     216,809,697     615,056    104,396 512267/10118
                                                               4/1603/2/0
process allocation               49,534         118         48 74/41/2/1/0
process group creation           90,286          10          8 2/8/0/0/0
redo writing                 11,209,235         100         21 79/21/0/0/0
row cache enqueue latch     767,813,675   1,434,242      6,620 1427651/6563