In this article we are going to see about ORA-4031 Analysis On Large Pool .
ORA-4031 Analysis On Large Pool and memory issue
Step:-1 Download script:–
Step:-2 Execute the script and find the large pool size
Log in to the database
Connect as the SYSDBA user.
Download the attached Largepool_db_ora4031.sql script.
Run the Largepool_db_ora4031.sql script while saving output to a spool file:
Connect with me on:-
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba