On Oracle
Thursday, March 27, 2014
dbms_aq.dequeue - latch: row cache objects on AIX
›
dbms_aq.dequeue uses an ADT object_type to pick payload from queue, and this can cause a heavy latch: row cache objects (latch#: 280 an...
Tuesday, March 11, 2014
Hot Block Identification and latch: cache buffers chains
›
When Hot Block Event: latch: cache buffers chains buffer busy waits occurs intensively, system performance is sluggish and CPU ...
Wednesday, November 27, 2013
Remove Stale Native Code Files on AIX
›
3 days after posting Blog: PGA, SGA space usage watching from UNIX about ipcs command for Oracle SGA, there was a problem reported on ...
Tuesday, November 19, 2013
PGA, SGA memory usage watching from UNIX
›
In the last two Blogs, we talked about how to measure PL/SQL package PGA memory usage and investigate ORA-04030 errors in incident file and ...
‹
›
Home
View web version