How do I see the Oracle Query execution plan?

oracle| Statement | The autotrace that executes Sqlplus is a very simple and convenient tool for analyzing SQL's execution plan, execution efficiency, and, in most cases, a very useful tool.

1. How to set up and use Autotrace

Sql> Connect/as SYSDBA
Sql> @?/rdbms/admin/utlxplan.sql

Table created.

sql> create public synonym plan_table for plan_table;

Synonym created.

Sql> Grant Select,update,insert,delete on plan_table to public;

Grant succeeded.

Sql> @?/sqlplus/admin/plustrce.sql
Sql>grant plustrace to public.

2. Understanding and Using Autotrace
For SQL tuning, using Autotrace is the easiest way to do this, and we just need to do this:
Sql>set Autotrace on
We can see our SQL execution plan, execution cost (physical read/consistent READ ...)
Plus set Timing on or set time on, we can get a lot of the data we need.

Then you can see the execution plan for this statement by pressing the ctrl+e on a SQL statement inside the toad.