On Oracle
Thursday, June 27, 2013
Oracle PL/SQL Collection Memory Reclaim
›
Oracle PL/SQL collection includes associative array, nested table and varray array, which are often used to store large amount of data. Cons...
Tuesday, June 4, 2013
dbms_alert lock hash collision
›
dbms_alert package calls dbms_lock to synchronize alert senders and receivers based on lockid generated by the name in dbms_alert_info table...
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 ...
‹
›
Home
View web version