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"

Answer / bharath

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

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  

---

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  

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

0 Answers  

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

0 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

What types of replication are supported in sql server? : sql server DBA

0 Answers  

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

How can you enable a trace for a session?

1 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---