|
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
SQL> set autotrace on explain SQL> select * from plan_table;
no rows selected
Execution Plan ---------------------------------------------------------- Plan hash value: 103984305
---------------------------------------------------------- -
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------- -
| 0 | SELECT STATEMENT | | 1 | 11081 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| PLAN_TABLE$ | 1 | 11081 | 2 (0)| 00:00:01 |
----------------------------------------------------------- -
Note ----- - dynamic sampling used for this statement
|