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

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,

---

internal architecture

0 Answers   CSC,

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

What are the ways tablespaces can be managed and how do they differ?

2 Answers   IBM,

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

How many memory layers are in the shared pool?

3 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 is the default fill factor value? : sql server DBA

0 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---