Shared memory problem with oracle 8.0.6

[Chris B]

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.

[James A. Donovan · Accepted solution]

|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.

[Alexander M. Ermes]

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

[Dragan Krnic_2]

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

[Dieter Degrendele_1]

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

[Chris B]

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.

[Alexander M. Ermes]

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