shared pool error upon login
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 2 Dec 2008 09:36:45 -0600
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
Other related posts:
