On Oracle
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 ...
Tuesday, November 5, 2013
ORA-04030 incident file and alert.log
›
In the last two Blogs, we talked about how to measure PL/SQL package PGA memory usage and different ways to reclaim unused memory: db...
Monday, September 16, 2013
Execution Switching between "direct path read" and "db file scattered read"
›
Oracle’s locking principle: blocking is only eligible among writers. Reader never blocks writer, and writer never blocks reader. What ...
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...
‹
›
Home
View web version