topic Shared memory problem with oracle 8.0.6 in Operating System - HP-UX

Shared memory problem with oracle 8.0.6

Chris B — Wed, 28 Feb 2001 16:39:40 GMT

Need some suggestions,
K460, HP-UX 10.20,Oralce 8.0.6,1.8GB mem, with 85% memory utilization.
We are getting following errors...SQL*Plus: Release 8.0.6.0.0 - Production on Mon Feb 26 16:50:37 2001

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter password:
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN
DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN
DBMS_APPLICATION_INFO....","PL/SQL MPCODE","BAMIMA: Bam Buffer")

any help.. any suggestions.....Thanks in advance.....
Chris.

Re: Shared memory problem with oracle 8.0.6

James A. Donovan — Wed, 28 Feb 2001 16:55:10 GMT

|corvette|oracle|sceaprod> oerr ora 4031
04031, 00000, "unable to allocate %s bytes of shared memory (\"%s\",\"%s\",\"%s")"
// *Cause: More shared memory is needed than was allocated in the shared
// pool.
// *Action: Either use the dbms_shared_pool package to pin large packages,
// reduce your use of shared memory, or increase the amount of
// available shared memory by increasing the value of the
// init.ora parameter "shared_pool_size".

Looks like your SGA needs tuning.

Re: Shared memory problem with oracle 8.0.6

Alexander M. Ermes — Thu, 01 Mar 2001 06:45:30 GMT

Hi there.
On the HP-UX 10.20 you should not exceed an SGA size of 1.75 GB. This is limited by the 32-bit OS you are using.
If you have several databases running on that machine, all the SGA's added should not exceed
that magic number. For the tuning first use the pinning. That takes a lot of load away from the memory.
Rgds
Alexander M. Ermes

Re: Shared memory problem with oracle 8.0.6

Dragan Krnic_2 — Thu, 01 Mar 2001 09:50:49 GMT

Alexander, what's pinning ? I must have missed something at the course.

Re: Shared memory problem with oracle 8.0.6

Dieter Degrendele_1 — Thu, 01 Mar 2001 13:20:48 GMT

Hi,

As mentioned by another user, I should increase the SGA of oracle by modifying the initXXX.ora file. For a database with some gigs of info, you could set it to 50Mb.

Sometimes (with Oracle Reports) it is required to change the kernel parameter MAXDSIZ to 256 Mb.

Regards,
Dieter

Re: Shared memory problem with oracle 8.0.6

Chris B — Thu, 01 Mar 2001 14:26:45 GMT

Alex,
We don't have SGA more than 1.75, as total memory is 1.8 and currently 85%+ used.
Do you have any links where we can look for tunning stuff, you mentioned.
Thanks.

Re: Shared memory problem with oracle 8.0.6

Alexander M. Ermes — Thu, 01 Mar 2001 15:23:40 GMT

Hi Chris.
Look at the message titled 'Attention Dragan Krnic'.
I posted a message with an attachment to pin packages.
If you have any questions, email me at :
Alexander_Ermes@web.de

Rgds
Alexander M. Ermes