There's also a note that contains good explanations plus cool toolkits/scripts that you could use. ORA-4031 Common Analysis/Diagnostic Scripts Doc ID: 430473.1 - Karl Arao karlarao.wordpress.com karlarao.tiddlyspot.com -- //www.freelists.org/webpage/oracle-l