Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-4031 oracle 10G release 2 solaris

Re: ORA-4031 oracle 10G release 2 solaris

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Oct 2005 09:10:10 -0700
Message-ID: <1129824603.717262@yasure>


Matthias Hoys wrote:

>>
>>This is the sga
>>
>>Total System Global Area 171966464 bytes
>>Fixed Size 1977208 bytes
>>Variable Size 113251464 bytes
>>Database Buffers 50331648 bytes
>>Redo Buffers 6406144 bytes
>>
>>
>>I dont know what to do HELP
>>

>
> Have you tried increasing the shared pool size ?

By way of comparison this is what I have with my little 10gR2 install on my laptop.

Total System Global Area 171966464 bytes

  Fixed Size                  1977208 bytes
  Variable Size             113251464 bytes
  Database Buffers           50331648 bytes
  Redo Buffers                6406144 bytes

Exactly the same. Makes me think the OP did a vanilla install, likely didn't adjust kernel parameters, and certainly did not give much thought to adjusting the init.ora values to correspond with the hardware and requirements.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Thu Oct 20 2005 - 11:10:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US