Oracle跟踪分析数据库启动的各个阶段

目录

• 启动到nomount状态
• 设置trace
• 启动数据库到mount状态并打开
• 查阅trace
• 查阅trace的另外方法 v$diag_info 视图

演示如下：

启动到nomount状态

[email?protected]> startup nomount;
ORACLE instance started.

Total System Global Area 1720328192 bytes
Fixed Size          2253944 bytes
Variable Size         754977672 bytes
Database Buffers      956301312 bytes
Redo Buffers            6795264 bytes

设置trace

[email?protected]> oradebug setmypid;
Statement processed.
[email?protected]> oradebug tracefile_name;
/oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/trace/kyeupdbfs_ora_13343.trc
[email?protected]> alter session set events ‘10046 trace name context forever,level 12‘;

Session altered.

启动数据库到mount状态并打开

[email?protected]> alter database mount;

Database altered.

[email?protected]> alter database open;

Database altered.

查阅trace

路径：/oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/trace/kyeupdbfs_ora_13343.trc

查阅trace的另外方法 v$diag_info 视图

[email?protected]> select * from v$diag_info where name like ‘%Trace%‘;

   INST_ID NAME         VALUE
---------- -------------------- --------------------------------------------------
     1 Diag Trace       /oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/
                trace

     1 Default Trace File   /oracle/app/oracle/diag/rdbms/kyeupdbfs/kyeupdbfs/
                trace/kyeupdbfs_ora_13343.trc

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!