Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Shared memory problem with oracle 8.0.6

SOLVED
Go to solution
Chris B
Occasional Advisor

Shared memory problem with oracle 8.0.6

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.
Chance happens to all but turn it to account is gift of few.
6 REPLIES
James A. Donovan
Honored Contributor
Solution

Re: Shared memory problem with oracle 8.0.6

|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.
Remember, wherever you go, there you are...
Alexander M. Ermes
Honored Contributor

Re: Shared memory problem with oracle 8.0.6

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"

Re: Shared memory problem with oracle 8.0.6

Alexander, what's pinning ? I must have missed something at the course.
no quote
Dieter Degrendele_1
Frequent Advisor

Re: Shared memory problem with oracle 8.0.6

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
The possible we did, the unpossible we're doing but for a miracle you have to wait some time.
Chris B
Occasional Advisor

Re: Shared memory problem with oracle 8.0.6

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.
Chance happens to all but turn it to account is gift of few.
Alexander M. Ermes
Honored Contributor

Re: Shared memory problem with oracle 8.0.6

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
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"