Oracle 9i与10g中plan_table的不同-体系架构

 sys@DG1> select * from v$version; 网管u家www.bitscn.net

BANNER
--------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production 网管网www_bitscn_com

sys@DG1> set autotrace on explain;
sys@DG1> select * from plan_table;

no rows selected

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE
1 0 TABLE ACCESS (FULL) OF 'PLAN_TABLE'

网管u家u.bitscn@com

 SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Prod
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for Solaris: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production 网管网www.bitscn.com

SQL> set autotrace on explain
SQL> select * from plan_table; 网管朋友网www_bitscn_net

no rows selected

Execution Plan
----------------------------------------------------------
Plan hash value: 103984305

网管联盟bitsCN_com

----------------------------------------------------------
- 网管联盟bitsCN_com

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
| 网管bitscn_com

----------------------------------------------------------
-

中国网管论坛bbs.bitsCN.com

| 0 | SELECT STATEMENT | | 1 | 11081 | 2 (0)| 00:00:01
|

网管u家u.bitscn@com

| 1 | TABLE ACCESS FULL| PLAN_TABLE$ | 1 | 11081 | 2 (0)| 00:00:01
|

-----------------------------------------------------------
-

网管网www_bitscn_com

Note
-----
- dynamic sampling used for this statement

网管u家bitscn.net