RE: SGA Fragmentation - How to Monitor

  • From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
  • To: <karlarao@xxxxxxxxx>, <moovarkku.mudhalvan@xxxxxxxxxxxxxxxx>
  • Date: Wed, 10 Mar 2010 11:37:00 -0500

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


Other related posts: