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

0 vote175 views1 answer
Mysql 1 hour ago
SQL
0 vote185 views1 answer
Oracle session statistics
SQL
-1 vote187 views4 answers
Restart mysql server ubuntu
SQL
0 vote193 views1 answer
Mysql range of dates overlap
SQL
0 vote171 views1 answer
Psql select * from table
SQL
0 vote178 views1 answer
Min and max salary and name in sql
SQL
0 vote191 views1 answer
Distance calculator from lat long sql query
SQL
0 vote172 views1 answer
Sql query to select records entered in last 24 hours
SQL
3 votes180 views3 answers
How to add month in update sql
SQL
0 vote185 views1 answer
How to query without duplicate rows in sql
SQL