| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> intermittent library cache pin/lock problems
We are seeing intermittent library cache pin/lock problems. The
problem occurs for about a min and then goes away. This of course
causes timeouts all over the place.
Any clue on where to start?
We generally have use bind variables..
Relevant settings
cursor_sharing string EXACT
cursor_space_for_time boolean TRUE
session_cached_cursors integer 100
snapshot of sgastat:
POOL NAME BYTES
----------- ------------------------------ ----------
fixed_sga 745744
buffer_cache 301989888
log_buffer 1311744
shared pool errors 71368
shared pool enqueue 15296336
shared pool KGK heap 7000
shared pool KQR L PO 840600
shared pool KQR M PO 804584
shared pool KQR S SO 10496
shared pool KQR X PO 1517280
shared pool sessions 25295920
shared pool sql area 34301824
shared pool KGLS heap 1743656
shared pool processes 11152000
shared pool db_handles 9860000
shared pool parameters 6792
shared pool free memory 108671032
shared pool transaction 16894064
shared pool PL/SQL DIANA 997064
shared pool FileOpenBlock 16270720
shared pool PL/SQL MPCODE 324152
shared pool library cache 75286624
shared pool miscellaneous 289621728
shared pool pl/sql source 6424
shared pool PLS non-lib hp 3320
shared pool joxlod: in ehe 294808
shared pool joxs heap init 1544
shared pool sim memory hea 674624
shared pool table definiti 3184
shared pool trigger defini 3192
shared pool trigger inform 664
shared pool type object de 85136
shared pool VIRTUAL CIRCUITS 19097080
shared pool dictionary cache 3229952
shared pool event statistics per sess 105823760
shared pool fixed allocation callback 576
large pool free memory 167669432
large pool session heap 838963528
java pool free memory 62521344
java pool memory in use 4587520
.......
 |
 |