Unfortunately, Yes. Try metalink note 215858.1 where the use of hanganalyze is offered. I believe this might help in your situation, next time.

>>> "Williams, Gerald H." <[Email Address Removed] 01/30/04 09:20AM >>>
I'm currently supporting an Oracle 8.1.7.2 64-bit database running on a
HP-9000 N-class Unix server. The OS is HP-UX 11.0 Yesterday afternoon,
the database, for lack of a better description, became frozen. Any
attempts to connect to the database simply went into a hung state. Any
select or DML statements went into a paused state. The alert log showed
no errors, warnings of any time at the time of the failure. My only
recourse was to perform a shutdown abort of the database and to start it
back up.

Has anyone run into a similar situation?

Gerald Williams
JEA Technology Services
voice: (904) 665-6287
fax: (904) 665-7411
e-mail: [Email Address Removed]



--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed]
To subscribe: send a blank email to oracledba-[Email Address Removed]
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page