RE: Database hanging/crashing repeatedly
Date: Tue, 18 Oct 2011 17:16:51 -0500
Message-ID: <6548C7B531E1364BAE8F77112F31A119A9040626_at_MSPM1BMSGM22.ent.core.medtronic.com>
There were 80+ parallel processes running on a system with 8 cpus. By running fewer processes at a time the server will be able to complete them faster than if you run all 80 at the same time. So we changed the parallel_max_servers parameter from 160 to 6 after that database is working better and the load cpu load looks much better.
Thanks,
Ashoke Mandal
From: Sidney Chen [mailto:huanshengchen_at_gmail.com]
Sent: Thursday, October 06, 2011 8:01 AM
To: Mandal, Ashoke
Cc: oracle-l-bounce_at_freelists.org; oracle-l_at_freelists.org
Subject: Re: Database hanging/crashing repeatedly
what's the server loading during the issue, CPU usage and run queue length, you can use sar to review. and is any top process found by ps/top, heavy paging/swap during the issue?
next time see if you can login with prelim and do a system dump to help analysis
sqlplus -prelim /nolog
SQL> conn / as sysdba
Prelim connection established
SQL> oradebug setmypid
Statement processed.
SQL> oradebug dump systemstate 1;
Statement processed.
you can use the os tool truss to trace sqlplus process, to see what's waiting on, see note 760968.1 truss -o connect.out -f sqlplus / as sysdba
--
Regards
Sidney Chen
[CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records.
To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 18 2011 - 17:16:51 CDT