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 vote109 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote103 views1 answer
Sql select table header
SQL
2 votes114 views1 answer
Oracle trace session
SQL
5 votes109 views1 answer
How to check nls format in oracle
SQL
0 vote111 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
0 vote133 views1 answer
Postgresql replace html tags from string
SQL
0 vote122 views1 answer
Sql server concat null
SQL
0 vote118 views2 answers
Jsonb
SQL
4 votes122 views1 answer
Conda install sqlalchemy
SQL
0 vote143 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL