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
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what are the performance views in an oracle rac environment?
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.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain about your sql server dba experience? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
what is a crs resource?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
internal architecture
