SGA how big ???

From: Teresa <tpreto7_at_sapo.pt>
Date: 30 Sep 2002 16:42:04 -0700
Message-ID: <6dabc692.0209301542.c5e6989@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
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
Thanks
Teresa Received on Mon Sep 30 2002 - 18:42:04 CDT