SQL> set autotrace on;
SP2-0613: 无法验证 PLAN_TABLE 格式或实体
SP2-0611: 启用EXPLAIN报告时出错
执行utlxplan.sql在$ORACLE_HOME/rdbms/admin下
SQL> @F:/oracle/ora92/rdbms/admin/UTLXPLAN.SQL
表已创建。
SQL> SET AUTOTRACE ON;
SQL> SELECT * FROM V$INSTANCE;
INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
HOST_NAME
----------------------------------------------------------------
VERSION STARTUP_TI STATUS PAR THREAD# ARCHIVE LOG_SWITCH_
----------------- ---------- ------------ --- ---------- ------- -----------
LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST
---------- --- ----------------- ------------------ ---------
1 ncdbpx
KJC03
9.2.0.5.0 14-3月 -05 OPEN NO 1 STARTED
ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 NESTED LOOPS
2 1 NESTED LOOPS
3 2 FIXED TABLE (FULL) OF 'X$QUIESCE'
4 2 FIXED TABLE (FULL) OF 'X$KVIT'
5 1 FIXED TABLE (FULL) OF 'X$KSUXSINST'
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
0 consistent gets
0 physical reads
0 redo size
1295 bytes sent via SQL*Net to client
503 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed