Shulou(Shulou.com)06/01 Report--

Starting with ORACLE 10g, sqlplus provides a parameter-prelim, which can still be logged into the database through sqlplus -prelim / as sysdba in the case where the database hangs. Combined with the oradebug command, you can export the details of the current hang in the database.

the specific method is execute according to that follow steps

sqlplus -prelim / as sysdba

oradebug setmypid

oradebug unlimit

oradebug dump systemstate 226

oradebug dump systemstate 226

oradebug tracefile_name

SQL> oradebug help

For the use of oradebug, see my other blog blog.itpub.net/30126024/viewspace-2218757/

Introduction on metalink

Hanganalyze

sqlplus '/ as sysdba'

oradebug setmypid

oradebug unlimit

oradebug hanganalyze 3

-- Wait one minute before getting the second hanganalyze

oradebug hanganalyze 3

oradebug tracefile_name

exit

Systemstate

sqlplus '/ as sysdba'

oradebug setmypid

oradebug unlimit

oradebug dump systemstate 266

oradebug dump systemstate 266

oradebug tracefile_name

exit

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.