oracle hang systemstate dump

可以连接数据库

1.single instance

sqlplus -prelim / as sysdba

–dump systeminfo

oradebug setmypid
oradebug unlimit
oradebug dump systemstate 266
— wait 1 minute
oradebug dump systemstate 266
oradebug tracefile_name

–dump hang analyze info

oradebug setmypid
oradebug unlimit
oradebug dump hanganalyze 3
— wait 1 minute
oradebug dump hanganalyze 3
oradebug tracefile_name;

2. RAC database

11g:

sqlplus ‘/ as sysdba’
oradebug setorapname reco
oradebug unlimit
oradebug -g all hanganalyze 3
oradebug -g all hanganalyze 3
oradebug -g all dump systemstate 266
oradebug -g all dump systemstate 266
exit

10g:

sqlplus ‘/ as sysdba’
oradebug setmypid
oradebug unlimit
oradebug -g all hanganalyze 3
oradebug -g all hanganalyze 3
oradebug -g all dump systemstate 258
oradebug -g all dump systemstate 258
exit

systemstate dump level:

level2 – dump(exclude the lock element)
level10 – dump
level11 – dump + global cache of RAC
level256 – short stack
level258 – 256 + 2
level266 – 256 + 10
level267 – 256 + 11

level11 and level267 will generate a bigger trace file, so don’t recommend to use.

数据库库无法连接

How to Collect Systemstate Dumps When you Cannot Connect to Oracle (Doc ID 121779.1)

此条目发表在Troubleshoot分类目录。将固定链接加入收藏夹。

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s