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 vote123 views1 answer
Inner joint
SQL
1 vote116 views1 answer
Update mysql centos
SQL
0 vote165 views1 answer
Get initials name in sql
SQL
1 vote142 views1 answer
Oracle user last connection date
SQL
1 vote139 views1 answer
How to group by month using sql server
SQL
0 vote137 views1 answer
Get last date join sql
SQL
0 vote137 views1 answer
Influxdb clone measurement
SQL
0 vote160 views1 answer
Insert output identity
SQL
0 vote124 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote129 views1 answer
Snap craft
SQL