How would you go about generating an EXPLAIN plan?

Question Posted / guest

2 Answers
8187 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you go about generating an EXPLAIN plan?..

Answer / daid kumar

The EXPLAIN PLAN statement displays execution plans chosen
by the Oracle optimizer for SELECT, UPDATE, INSERT, and
DELETE statements.
Run This Script To create Plan Table
$ORACLE_HOME/rdbms/admin/UTLXPLAN.SQL
Then Write like this
SQL> EXPLAIN PLAN FOR
SELECT name FROM emp;

Now to see O/P u can select * from "plan_table"

Is This Answer Correct ?

9 Yes

1 No

How would you go about generating an EXPLAIN plan?..

Answer / bharath

explain plan for select * from t1 where num_col = '1';
select * from table(dbms_xplan.display);

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More DB Administration Interview Questions

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

Where in the Oracle directory tree structure are audit traces placed?

1 Answers

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers

How would you begin to troubleshoot an ORA-3113 error?