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
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
how can you create a user-defined lock?
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.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How can you control the amount of free space in your index pages? : sql server DBA
what are the performance views in an oracle rac environment?
what are the types of connection load-balancing?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
