Answer Posted / 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"

What is replication? : sql server DBA

1176

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2464

---

how can you create a user-defined lock?

1019

---

what are the types of connection load-balancing?

1000

---

what functionality does oracle provide to secure sensitive information?

994

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

1068

---

how can you record information about current session?

1049

---

Why does Oracle not permit the use of PCTUSED with indexes?

2942

---

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

2109

---

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.

2282

---

how can you connect from 10g user to 11g user??

2115

---

Can you redefine a table online?

1117

---

how can a session indicate its interest in receiving alerts?

1044

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2113

---

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

1760

---