| From: | Steve Adams |
| Date: | 14-Dec-2000 04:54 |
| Subject: | library cache latch contention |
|
|
Well done on your investigation so far. To get the same number of library cache latches on both nodes you can set the _kgl_latch_count parameter to 29. Alternatively, you can probably resolve the problem by just reducing the shared pool size. The large number of objects on child library cache latch #1 is probably indicative of a problem with a large version count. Please check with APT Script version_count.sql.
|
![]() |
Platform
Problem
Action/Investigation
alter session set events 'immediate trace name library_cache level 3'From the trace file I grep the latch= pattern and counted for each latch number (the output is given below). The output shows the distribution of latch and latch 1 is very hot. (Am I interpreting correctly?)
Question
latch 0 = 368 latch 1 = 3061 latch 2 = 407 latch 3 = 375 latch 4 = 366 latch 5 = 354 latch 6 = 387 latch 7 = 376 latch 8 = 388 latch 9 = 422 latch 10 = 390 latch 11 = 379 latch 12 = 386 latch 13 = 396 latch 14 = 398 latch 15 = 392 latch 16 = 348
|