Hello,
Under what conditions did you get this error? If it's under your normal
working conditions then increase your shared pool by a large number. If
it's under your peak usage then increase your shared pool by a bit less.
Exact numbers will depend on your own situation.
HTH,
- pschauss_at_parker.com wrote:
> One of our application processes got the following error:
>
> ORA-04031: unable to allocate 4216 bytes of shared
> memory ("shared pool","unknown object","sga heap","library cache")
>
> The Error Messages manual says that the cure it either to use
> dbms_shared_pool package to pin large packages into memory,
> reduce use of shared memory, or increase the value of the
> SHARED_POOL_SIZE
> parameter.
>
> If we opt for the latter, how do we know how much larger to make it?
>
> Is there some system table or view which will tell give us a
> high water mark on use of shared pool so we can tell how much room
> we've got once we increase this parameter?
>
> The code which caused the error was a SET TRANSACTION READ ONLY
> statement in PRO*C. How was this putting us over the limit
> on our shared pool usage?
>
> thanks,
> Peter Schauss
> Parker Hannifin Corp
> Smithtown, NY
>
>
> --
> Author:
> INET: pschauss_at_parker.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).
Rocky Welch
Oracle DBA Consultant
rockyw_99_at_yahoo.com
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
Received on Thu Jun 15 2000 - 14:04:44 CDT
