重现Oracle数据库Hang住的情况(二)
[oracle@resoft ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:23:45 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 845348864 bytes
Fixed Size 1348216 bytes
Variable Size 595594632 bytes
Database Buffers 243269632 bytes
Redo Buffers 5136384 bytes
Database mounted.
Database opened.
数据库hang住时信息收集：
[oracle@resoft ~]$ sqlplus -prelim / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Fri Apr 12 23:29:27 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> oradebug setmypid;
Statement processed.
SQL> oradebug dump systemstate 266;
Statement processed.
SQL> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/orcl/ORCL/trace/ORCL_ora_4889.trc
接下来的事情就是分析，折腾数据库了…