Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Query processing is slow(eg select query)how will u solve that
What are the different types of indexes available in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
how to restore files with rman?
Where do you find the default index fill factor and how to change it? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
how can you find out if a table can be redefined?
what is a crs resource?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the commands used in dcl? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
