Re: shared pool error upon login
Date: Tue, 2 Dec 2008 10:03:26 -0600
You are running in to shared pool issues. Find out why shared pool free space is depleted or fragmented, to resolve this issue. See if v$sgastat provides any clues as to where shared pool space is spent.
That event [ ksfqp_limit] is to limit # of rows in x$ksfqp table. It is
possible that x$ksfqp is huge consuming shared pool space, but need further
review of shared pool dumps to confirm that. I don't have 8i handy to test
Who gave you that advice?
On Tue, Dec 2, 2008 at 9:36 AM, Joe Smith <joe_dba_at_hotmail.com> wrote:
> Upon logging into an 8i database this error ocurrs:
> SQL*Plus: Release 188.8.131.52.0 - Production on Tue Dec 2 07:36:13 2008
> ERROR: ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
> pool","BEGIN DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam
> Why would this event fix the problem?
> alter system set events='immediate trace name ksfqp_limit level 1';
> Then add this entry to the init.ora
> event = 'logon trace name ksfqp_limit level 1'
> Can somebody explain this to me?
> Suspicious message? There's an alert for that. Get your Hotmail(R) account
-- Riyaj Shamsudeen The Pythian Group www.pythian.com orainternals.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 02 2008 - 10:03:26 CST