How would you go about generating an EXPLAIN plan?
Answers were Sorted based on User's Feedback
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 |
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 |
What is the difference between Datapump & export/import?
Which environment variables are absolutely critical in order to run the OUI?
WHEN DOWN TIME WHAT CAN U DO?
How would you determine what sessions are connected and what resources they are waiting for?
How would you begin to troubleshoot an ORA-3113 error?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Where do you find the default index fill factor and how to change it? : sql server DBA
how can you connect from 10g user to 11g user??
How can you control the amount of free space in your index pages? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
How can you gather statistics on a table?
what is asm?