Description:-
In this article we are going to see about ORA-4031 Analysis On Large Pool .
Problem:-
ORA-4031 Analysis On Large Pool and memory issue
Demo:-
Step:-1 Download script:–
https://drive.google.com/file/d/1L85Xm2j45-T5Wy5RYdqU46dI9_4fOwEy/view?usp=sharing
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:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/hariprasathdba
