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

8 votes108 views3 answers
Postgres connection string
SQL
2 votes111 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote94 views1 answer
Pgadmin see indexes
SQL
0 vote99 views1 answer
Mysql 1 hour ago
SQL
3 votes141 views1 answer
Oracle nextval insert
SQL
3 votes128 views5 answers
Duplicate table sql
SQL
9 votes140 views1 answer
No sql
SQL
47 votes172 views6 answers
Add column mysql
SQL
11 votes118 views1 answer
Oracle export view ddl
SQL
4 votes104 views1 answer
Update table from another table oracle
SQL