Re: Production db server getting freezed

From: Saurabh Sood <email2sood_at_gmail.com>
Date: Sat, 5 Feb 2011 13:45:52 +0530
Message-ID: <AANLkTim6HP8ehAHUWm4JjFjjNRDmM8guFx_PSZzpjrUs_at_mail.gmail.com>



Hi Krishna,

If your database is getting freezed and not allowing any connections then login by using "sqlplus -prelim / as sysdba" and take systemstate dumps as:

sql> oradebug setmypid
sql> oradebug unlimit
sql> oradebug dump systemstate 266

wait for couple of minutes

sql> oradebug dump systemstate 266

wait for couple of minutes

sql> oradebug dump systemstate 266

sql> oradebug tracefile_name

open the trace file and look for specific wait events, this will give you a hint where you have stuck..

With Regards,
Saurabh Sood
www.askdba.org/weblog

On Sat, Feb 5, 2011 at 12:00 PM, KRISHNA MOORTHY <krish33moorthy_at_gmail.com>wrote:

> Hi
>
> Our production database server is getting frrezed suddenly yesterday..There
> is no deadlock or any unknown errors in alert log file.
>
> Oracle database version : 10.0.2.0
> OS : RedHatLinux 5.2
>
> Please share your thoughts to analyze the issue.What kind of logs or
> settings i need to look in to this issue at OS level and db level.
>
> Regards
> Krishna
>

-- 
SAURABH SOOD
ORA-DBA

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Feb 05 2011 - 02:15:52 CST

Original text of this message