Re: Production db server getting freezed

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@xxxxxxxxx>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

Other related posts: