Database Administrator (DBA) Question: Download Questions PDF
How would you go about generating an EXPLAIN plan?
Answer:
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
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
Download Database Administrator (DBA) Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is a Synonym? | How would you go about increasing the buffer cache hit ratio? |