shared pool error upon login
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 2 Dec 2008 09:36:45 -0600
Message-ID: <BLU108-W202F0E9A8D6FED1338A0A597000@phx.gbl>
Suspicious message? There’s an alert for that. http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad2_122008
Date: Tue, 2 Dec 2008 09:36:45 -0600
Message-ID: <BLU108-W202F0E9A8D6FED1338A0A597000@phx.gbl>
Upon logging into an 8i database this error ocurrs:
SQL*Plus: Release 8.1.7.0.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 Buffer")
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?
thanks.
Suspicious message? There’s an alert for that. http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad2_122008
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 02 2008 - 09:36:45 CST