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

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

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

1 Answers  

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

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.

0 Answers   Infosys,

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

0 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

what are the differences of where and if in SAS?

0 Answers  

---