Oracle 11.2.0.4,啟動至 MOUNT 階段,啟用 10046 Event 追蹤 OPEN 過程。
SQLPLUS / AS SYSDBA
STARTUP MOUNT;
ORADEBUG SETMYPID;
ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';
ALTER DATABASE OPEN;
ORADEBUG TRACEFILE_NAME; -- 取得 trace 檔路徑
ALTER SESSION SET EVENTS '10046 TRACE NAME CONTEXT OFF';
WAIT #...: nam='db file sequential read' ela= 460 file#=1 block#=520 blocks=1 obj#=-1 tim=...
PARSING IN CURSOR #... len=188 dep=1 uid=0 oct=1 lid=0 tim=... hv=4006182593 ad='91871900' sqlid='32r4f1brckzq1'
create table bootstrap$ ( ...
EXEC #...: c=0 e=17461 p=0 cr=0 cu=0 mis=0 r=0 dep=1 og=4 plh=0 tim=...
PARSING IN CURSOR #... len=55 dep=1 uid=0 oct=3 lid=0 tim=... hv=2111436465 ad='9185fc98' sqlid='6apq2rjyxmxpj'
select line#, sql_text from bootstrap$ where obj# != :1
BINDS #...: value=59
FILE#=1 BLOCK#=520 (Bootstrap$ 表所在區塊)。BOOTSTRAP$ 表,取得核心字典物件的 DDL (如 CREATE TABLE ...) 載入 Library Cache。BOOTSTRAP$ 為 Oracle 核心字典表,儲存關鍵物件建立 SQL,OBJECT_ID=59 (SYS)。
SELECT dbms_metadata.get_ddl('TABLE','BOOTSTRAP$','SYS') FROM dual;
SELECT owner, object_id FROM dba_objects WHERE object_name='BOOTSTRAP$';
-- OWNER=SYS, OBJECT_ID=59
db file sequential read file#=1 block#=520,可能是系統表空間 I/O 故障或 Bootstrap$ 損壞。