Oracle Database Discussions

Hi All,

I've severe latching problem in my database, when I look in AWR but confused what is causing it.
Can someone guide me on this?
NoWait Waiter
Latch Name Where Misses Sleeps Sleeps
------------------------ -------------------------- ------- ---------- --------
In memory undo latch ktiFlush: child 0 5 0
In memory undo latch kturbk 0 2 2
cache buffers chains kcbchg: kslbegin: bufs not 0 573 69
cache buffers chains kcbgtcr: fast path 0 380 554
cache buffers chains kcbgtcr: kslbegin excl 0 298 547
cache buffers chains kcbrls: kslbegin 0 183 153
cache buffers chains kcbzgb: scan from tail. no 0 83 0
cache buffers chains kcbibr 0 31 40
cache buffers chains kcbchg: kslbegin: call CR 0 10 70
cache buffers chains kcbgcur: kslbegin 0 4 13
cache buffers chains kcbget: pin buffer 0 3 72
cache buffers chains kcbnew: new latch again 0 3 18
cache buffers chains kcbzwb 0 2 3
cache buffers chains kcbbxsv 0 1 3
cache buffers chains kcbcge 0 1 5
cache buffers lru chain kcbzgws 0 45 0
cache buffers lru chain kcbibr 0 43 97
cache buffers lru chain kcbo_link_q 0 20 5
cache buffers lru chain kcbw_quiesce_granule 0 5 0
cache buffers lru chain kcbgtcr:CR Scan:KCBRSKIP 0 1 0
enqueues ksqdel 0 1 0
kks stats kks stats alloc/free 0 1 1
library cache kglobpn: child: 0 2,978 4,471
library cache kgldti: 2child 0 2,417 12
library cache kglLockCursor 0 1,604 3,398
library cache kglpin 0 1,426 538
library cache kglpndl: child: after proc 0 1,185 7
library cache kglhdgn: child: 0 766 1,485
library cache kglpnp: child 0 618 8,902
library cache kglhdgc: child: 0 331 0
library cache kgldte: child 0 0 95 809
library cache kglpndl: child: before pro 0 92 1,800
library cache kglic 0 50 0
library cache kglnti 0 30 0
library cache kglati 0 28 0
library cache kglobld 0 15 21
library cache kglScanDependency 0 7 2
library cache kglukp: child 0 6 5
library cache kglhdbrnl: child 0 1 0
library cache lock kgllkdl: child: no lock ha 0 10,017 217
library cache lock kgllkdl: child: cleanup 0 87 119
library cache lock kgllkal: child: multiinsta 0 80 48
library cache lock alloc kgllkget 0 1 1
library cache pin kglpndl 0 34 6
library cache pin kglpnp: child 0 17 23
library cache pin kglpnal: child: alloc spac 0 13 35
object queue header oper kcbo_switch_cq 0 12 5
object queue header oper kcbw_link_q 0 9 11
object queue header oper kcbo_link_q:reget 0 5 0
object queue header oper kcbw_unlink_q 0 2 10
redo allocation kcrfw_redo_gen: redo alloc 0 13 0
row cache objects kqreqd: reget 0 7 0
row cache objects kqreqd 0 1 0
session allocation ksuprc 0 44 7
session allocation ksudlc 0 24 25
session allocation ksuxds: not user session 0 16 1
session allocation ksucri 0 9 62
session allocation kspallmod 0 2 0
shared pool kghalo 0 2,269 126
shared pool kghupr1 0 690 3,122

Thanks for the help.

Thanks,

Rana.