RE: Database hanging/crashing repeatedly

From: Mandal, Ashoke <>
Date: Tue, 18 Oct 2011 17:16:51 -0500
Message-ID: <>

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.

Ashoke Mandal

From: Sidney Chen [] Sent: Thursday, October 06, 2011 8:01 AM To: Mandal, Ashoke
Cc:; 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


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:

-- Received on Tue Oct 18 2011 - 17:16:51 CDT

Original text of this message