Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Altering dymanic SGA parameters and ORA-00376

RE: Altering dymanic SGA parameters and ORA-00376

From: Kerber, Andrew W. <>
Date: Thu, 6 Dec 2007 14:40:39 -0600
Message-ID: <>

Yes, I have seen it. Never did find a cause, and the theory I developed was one my unix sys admin did not like. Were there errors in the trace files about forking a process?  

-----Original Message-----
[] On Behalf Of
Sent: Thursday, December 06, 2007 10:14 AM To:; 'oracle-l' Subject: RE: Altering dymanic SGA parameters and ORA-00376  

I am unable to locate the bug number associated with a similar error I saw in the recent past, I will post that when I can locate it. Basically, if I remember this correct the database instance crashes ( I believe) if you resize when the sga_target is a multiple of 4G. I think the circumstances were  

  2. DB_CACHE_SIZE was increased



[] On Behalf Of Peter McLarty
Sent: Thursday, December 06, 2007 7:58 AM To: oracle-l
Subject: Altering dymanic SGA parameters and ORA-00376  


I am sure this is a totally dumb question but does anyone know if changing parameters dynamically for SGA settings like increasing shared_pool_size can cause a DB to crash and show many problem datafiles with ORA-00376.

I am thinking SAN failure of some sort, we relocated the database to another set of LUNS from a different SAN and did datafile recovery and all is good, but just trying to isolate the causes, alert log shows a read error on an index datafile just seconds before it had the alter for the SGA parameters and then crash.

Interestingly it had to use 4 archivelogs to conduct the recovery which cover about 20 minutes prior to the crash.

Some hypothesis to consider ,based on the above information is what I am looking for.
It is Solaris 10 and its Sun Storage but i don't have available the models, the server is a T2200, 16 VCPU's

Or if someone has had a similar experience and what you found out We are going to try and do a root cause analysis tomorrow if no issues are present when the users hit it again

1am here and I am off to bed

All help appreciated


Peter McLarty <>
Pacific DBMS Pty Ltd 


NOTICE:  This electronic mail message and any attached files are confidential.  The information is exclusively for the use of the individual or entity intended as the recipient.  If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited.  If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.


Received on Thu Dec 06 2007 - 14:40:39 CST

Original text of this message