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

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

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

0 Answers  

---

how can you enable flashback feature?

0 Answers   Oracle,

---

When a user process fails, what background process cleans up after it?

1 Answers  

---

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?

0 Answers   HSBC,

---

Can we take incremental backups in datapump?

1 Answers  

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

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

1 Answers  

---

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---