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);

Hot backup procedure?

2 Answers  

---

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

---

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?

0 Answers  

---

What is dcl? : sql server DBA

0 Answers  

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

0 Answers  

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

0 Answers  

---

what is the differnce between process and thread ?

1 Answers   IBM,

---

What is the difference between LMT & DLT?

1 Answers   CTS,

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---