How the Oracle database collects ORA-00904 errors in the execution plan and resolution of the specified SQL

How the Oracle database collects ORA-00904 errors in the execution plan and resolution of the specified SQL

(Copyright notice, I original or translated articles for reprint, such as reprinted for Personal learning, please specify the source; otherwise please contact me, the offender must investigate)

How to collect the execution plan for the specified SQL is very important to the developer, where the underlying collection is recorded so that it can be consulted and referenced by others.

1. Link to sqlplus, as shown below

2. Execute one of the following two commands

Set autotrace on; (Note: Turn on automatic profiling statistics and display the results of the SQL statement running)

3. Enter and execute the SQL statement to collect the execution plan.

4. This implementation plan will be printed. As pictured above

< yo "http://www.2cto.com/kf/ware/vc/" target= "_blank" class= "Keylink" >vcd48cd7i57n71nrk1byvtcs5/ Bpm1tdt9rw9t1jbltawota0oizxdw90o09usevsx1rbryzx

Dw90ozqx6sq2t/vo3tcntctoyszio6zi58/czbw8l3a+pha+pgltzybzcmm9 "http://www.2cto.com/uploadfile/Collfiles/

20140403/201404030849428.jpg "alt=" "/>

Then we need

1. Drop off table plan_table first;

2. Use @ $ORACLE _home/rdbms/admin/utlxplan.sql to reconstruct plan_table, as shown below

3. The results of the collection implementation plan after the reconstruction are as follows.