RE: ora-04031 and x$ksmlru

Thanks, Raj.
This is helpful.
Tim also mentioned configuring the large pool (which I had not configured at all previously). Especially since we're using MTS. I've tried configuring the large pool, and I did decrease hash_area_size a bit. The let me bounce the database after they finished taking ad's for today's paper, so the new parameters are currently in effect. So now I have my fingers crossed real tight.

Thanks for your help!
Barb

> ----------
> From: Jamadagni, Rajendra[SMTP:Rajendra.Jamadagni_at_espn.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, May 16, 2002 1:57 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ora-04031 and x$ksmlru
>
> <<File: ESPN_Disclaimer.txt>>
> Barb,
>
> Check this discussion
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?
> p_
> database_id=BUG&p_id=2329533 it appears that this error is also related to
> large pool setting.
>
> There is some math given near the end of this discussion, and you could
> use
> that math on deriving large pool size (if this applies to you).
>
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect that of ESPN
> Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.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).