Answers

Question and Answer:

  Home  Database Administrator (DBA)

⟩ How would you go about generating an EXPLAIN plan?

Create a plan table with utlxplan.sql.

Use the explain plan set statement_id = 'tst1' into plan_table for a SQL statement

Look at the explain plan with utlxplp.sql or utlxpls.sql

 149 views

More Questions for you: