On a
side note, before I kill myself with the Friendly Manual, does anyone have a
fast way to determine how much space in the shared pool a package is
using?
Dick Goulet Senior Oracle DBA Oracle Certified 8i
DBA
Is there a way to catch
shared_pool fragmentation before you get the 4031 errors? I have looked
at Steve Adams site which has scripts to show the free lists chunks in the
shared pool. At what point do I know that it is fragmented too much?
I know that I can prevent this by using bind variables, and keeping
objects, but until I can modify all the apps, I would like to know a little
before these errors happen. Any ideas?
Thanks,
Rick Stephenson
This email and any files transmitted with it are
confidential and intended solely for the use of the individual or entity to
which they are addressed. This message contains confidential information and
is intended only for the individual named. If you are not the named addressee
you should not disseminate, distribute or copy this e-mail. Please notify the
sender immediately by e-mail if you have received this e-mail by mistake and
delete this e-mail from your system. If you are not the intended recipient you
are notified that disclosing, copying, forwarding or otherwise distributing or
taking any action in reliance on the contents of this information is strictly
prohibited.
|