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

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

RE: Altering dymanic SGA parameters and ORA-00376

From: Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
Date: Fri, 07 Dec 2007 10:52:31 +1000
Message-Id: <1196988751.6449.13.camel@notebook5.pacificdbms.com.au>


Hi

Thanks for your comments, Andrew IO can find no reference to fork events that might be in error.

I have been reviewing trace files in bdump and find no answer. It seems none were written all morning prior to the event. Andrew you and I may have came to a similar conclusion that the sysadmins might not like.

FYI SGA_TARGET is not set on this system, Oracle is not dynamically altering the settings. I the q still somewhat stumped as to what the real cause is, I guess closer monitoring of the system may answer question if it decides to turn its toes up again.

Put one down for experience on this one until a better answer comes along.

Metalink and Google have not shown anything that suggests that a problem may exist with altering shared_pool_size and db_cache_size parameters, except when you try to effectively increase then to the point it exceeds SGA_MAX_SIZE. maybe I didnt find the right query combination

Thanks again

Cheers

Peter

On Thu, 2007-12-06 at 14:40 -0600, Kerber, Andrew W. wrote:
> 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-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
> krish.hariharan_at_quasardb.com
> Sent: Thursday, December 06, 2007 10:14 AM
> To: peter.mclarty_at_pacificdbms.com.au; '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
> (10.2.0.3 I believe) if you resize when the sga_target is a multiple
> of 4G. I think the circumstances were
>
>
>
> 1. SGA_TARGET 12G
>
> 2. DB_CACHE_SIZE was increased
>
>
>
> Regards
>
> -Krish
>
>
>
>
>
> ______________________________________________________________________
>
> From:oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Peter McLarty
> Sent: Thursday, December 06, 2007 7:58 AM
> To: oracle-l
> Subject: Altering dymanic SGA parameters and ORA-00376
>
>
>
>
>
> Hi
>
> 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
>
> Cheers
>
> --
> Peter McLarty <peter.mclarty_at_pacificdbms.com.au>
> 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.
>
> ==============================================================================
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 06 2007 - 18:52:31 CST

Original text of this message

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