On Oracle
Friday, April 12, 2013
cursor: pin S wait on X
›
Oracle introduced mutex (replacing latch) to protect cursor and library cache, and consequently following wait events: cursor: mutex S ...
Shared Pool - Free Memory, Fragmentation ?
›
Facing: ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT MAX(XX) FROM...","SQLA...
Thursday, March 28, 2013
Shared Pool - SQLA and KGLH0
›
SQLA In the last Blog: Shared Pool - Memory Allocation - unbalanced , SQLA in Subpool_1 is desperately low allocated, Subpool_1 has ...
Shared Pool - Memory Allocation - unbalanced
›
Continuing from my last field experience of ORA-04031 ( Shared Pool - KKSSP ), I would like to share my further observation of Shared Pool ...
‹
›
Home
View web version