RE: Database hanging/crashing repeatedly
- From: "Mandal, Ashoke" <ashoke.k.mandal@xxxxxxxxxxxxx>
- To: Sidney Chen <huanshengchen@xxxxxxxxx>
- Date: Tue, 18 Oct 2011 17:16:51 -0500
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@xxxxxxxxx]
Sent: Thursday, October 06, 2011 8:01 AM
To: Mandal, Ashoke
Cc: oracle-l-bounce@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
