oracle oradebug systemstate 的日常使用详解数据库

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL set lines 200; SQL set pages 200; SQL select * from v$version; BANNER CON_ID -------------------------------------------------------------------------------- ---------- Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 0 PL/SQL Release 12.2.0.1.0 - Production 0 CORE 12.2.0.1.0 Production 0 TNS for Linux: Version 12.2.0.1.0 - Production 0 NLSRTL Version 12.2.0.1.0 - Production 0 SQL 创建测试表，插入测试数据

SQL create table tmp_peiyb_20180427 ( a varchar2(100),b varchar2(100)); 

Table created. 

SQL insert into tmp_peiyb_20180427(a,b) values(aa,bb); 

1 row created. 

SQL commit; 

Commit complete. 

SQL 

session 1 更新，不commit

SQL update tmp_peiyb_20180427 set b=cc where a=aa; 

1 row updated. 

SQL 

session 2 更新，会处于wait状态

SQL update tmp_peiyb_20180427 set b=cc where a=aa; 

session 3 使用sys执行 oradebug systemstate

SQL oradebug setmypid; 

Statement processed. 

SQL oradebug unlimit; 

Statement processed. 

SQL oradebug dump systemstate 266; 

Statement processed. 

SQL oradebug TRACEFILE_NAME; 

/u01/app/oracle/diag/rdbms/rac0/rac01/trace/rac01_ora_11369.trc 

SQL oradebug dump systemstate 266; 

Statement processed. 

SQL oradebug TRACEFILE_NAME; 

/u01/app/oracle/diag/rdbms/rac0/rac01/trace/rac01_ora_11369.trc 

SQL oradebug CLOSE_TRACE; 

Statement processed.

session 3 rac环境下使用sys执行 oradebug systemstate

SQL oradebug setmypid; 

Statement processed. 

SQL oradebug unlimit; 

Statement processed. 

SQL oradebug setinst all; 

Statement processed. 

SQL oradebug -g def dump systemstate 266; 

Statement processed. 

SQL oradebug TRACEFILE_NAME; 

/u01/app/oracle/diag/rdbms/rac0/rac01/trace/rac01_ora_13859.trc 

SQL oradebug CLOSE_TRACE; 

Statement processed.

无法登录数据库，需要添加 -prelim 参数

sqlplus -prelim / as sysdba;

原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/3903.html

oracle