Oracle Database Performance Topics
Hi, PLease give me tips for trouble shooting the oracle performance (11g R2 and R 12) . If possible also help me in regarding to solve the ora 4031 and ora 4030 errors in 11g R2.
Regarding Oracle performance troubleshooting – this is exactly what my blog is about, so I recommend reading my blog archives (http://blog.tanelpoder.com/archives/) and for memory troubleshooting, just search for 4030 in my blog or look into the list of articles here: http://blog.tanelpoder.com/2014/03/26/oracle-memory-troubleshooting-part-4-drilling-down-into-pga-memory-usage-with-vprocess_memory_detail/ . MOS also has good ORA-4031 troubleshooting notes, just search there.
Your email address will not be published. Required fields are marked *
Notify me of new posts by email.