Re: Production db server getting freezed
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-lReceived on Sat Feb 05 2011 - 02:15:52 CST