RE: ORA-04031

As one who has been there, I can sympathize. I had a TAR open for months
going back and forth with Oracle Support. The entire problem boiled down to
the fact that Oracle Corporation does not have a supported method
("supported" is the key word) to query the free chunks of the shared pool to
determine the amount of fragmentation. Fragmentation of the shared pool was
the most likely cause of our ORA-4031 errors, but because Oracle Support
said it couldn't be measured, I wasn't able to measure the effect of my
changes to the shared pool size and the pinning. Their answer was "bump up
the shared pool, bounce the instance, repeat" until it stopped.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).