Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-4031 oracle 10G release 2 solaris
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