Oracle跟蹤分析資料庫啟動的各個階段

標籤：session   rev   redo   ade   rdbms   rdb   fixed   HERE   app   

目錄

• 啟動到nomount狀態
• 設定trace
• 啟動資料庫到mount狀態並開啟
• 查閱trace
• 查閱trace的另外方法 v$diag_info 視圖

示範如下：

啟動到nomount狀態

[email protected]> startup nomount;ORACLE instance started.Total System Global Area 1720328192 bytesFixed Size          2253944 bytesVariable Size         754977672 bytesDatabase Buffers      956301312 bytesRedo 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

Oracle跟蹤分析資料庫啟動的各個階段