Oracle show execution plan

-- Without execution
EXPLAIN PLAN FOR select ...;
SELECT * FROM TABLE(dbms_xplan.display);
-- With execution
SELECT /*+ gather_plan_statistics */  ...;
SELECT * FROM TABLE(dbms_xplan.display_cursor(NULL,NULL,'ALLSTATS LAST'));

Similar codes

1 vote126 views2 answers
Postgresql list columns
SQL
11 votes139 views2 answers
Turn off safe mode mysql
SQL
0 vote124 views1 answer
Sql date between one week
SQL
0 vote145 views1 answer
How to access to mysql without root
SQL
0 vote155 views1 answer
Character count sql
SQL
1 vote124 views1 answer
How to get mysql db size
SQL
1 vote141 views1 answer
Postgresql define pk sequence next number
SQL
0 vote182 views1 answer
Do you know sql
SQL
0 vote125 views1 answer
What are the aggregate function in sql
SQL
0 vote228 views2 answers
Execute stored procedure without db set
SQL