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

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

what is a crs resource?

0 Answers   Oracle,

---

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

1 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

Name two files used for network connection to a database.

5 Answers  

---

What column differentiates the V$ views to the GV$ views and how?

3 Answers  

---

now one user in online.now i want drop him..how do u drop him?

4 Answers   Wipro,

---

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

0 Answers   Oracle,

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

How do you resize a data file?

2 Answers  

---