Re: shared pool error upon login

Hi Joe

   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 that either.
  Who gave you that advice?

Cheers
Riyaj
blog: http://orainternals.wordpress.com

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 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. Get your Hotmail(R) account
> now.<http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_broad2_122008>
>

-- 
Riyaj Shamsudeen
The Pythian Group www.pythian.com
orainternals.wordpress.com

--
http://www.freelists.org/webpage/oracle-l