Re: SGA how big ???

"Teresa" <tpreto7_at_sapo.pt> wrote in message news:6dabc692.0209301542.c5e6989_at_posting.google.com...
> Hi all
>
> I'm having the followgin problems with oracle 8174 64 bite on Sun 5.8
> 64 bite mode: Once in a while I get the ORA-04030 when I run some
> scrips, I have called oracle support, but everytime I call about this
> I get a different advice ... my SGA is the followin:
>
> SVRMGR> show sga
> Total System Global Area 1564495548 bytes

So your SGA is 1.5GB big. You don't say how much physical memory your Sun box has installed, but I hope it's at least 4GB?

> Fixed Size 102076 bytes
> Variable Size 330334208 bytes
> Database Buffers 1228800000 bytes
> Redo Buffers 5259264 bytes
>
>
> total: 5631672k bytes allocated + 13510208k reserved = 19141880k used,
> 17250280k
> available
>
> Oracle support 1 says reduce the sga another is to increase also one
> of them said that Oracle needed more memory which we got and know its
> worse. I don't know anymore what to to what to change ....etc
> any help would be great

Your specific memory error is, I hope,

ORA-04030 out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.

Not being a Sun expert, but that sounds to me like it's a problem with your operating system configuration, not anything to do with Oracle itself or its configuration. Increasing the SGA is only likely to make the 4030 problems worse, not better.

The words 'semaphores' and SHMMEM spring to mind as possible causes.

Not much help, I'm sure -but at least stop resetting the SGA init.ora parameters.

Regards
HJR
> Thanks
> Teresa
Received on Mon Sep 30 2002 - 18:55:55 CDT