If this is an Oracle Applications / Ebiz / ERP system you can also look into "pinning packages". This was a good thing to do under 8i and 9i, so I assume that it is still valid with Oracle 10g. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Karl Arao Sent: Wednesday, March 10, 2010 5:31 AM To: moovarkku.mudhalvan@xxxxxxxxxxxxxxxx Cc: Oracle-L@xxxxxxxxxxxxx Subject: Re: SGA Fragmentation - How to Monitor 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 -- //www.freelists.org/webpage/oracle-l