Answer / siva.k

A Shared SQL area is required to process every unique SQL
statement submitted to a database and contains information
such as the parse tree and execution plan for the
corresponding statement.

What is User Process?

1 Answers  

---

What is the function of Lock (LCKn) Process?

1 Answers  

---

What is the function of checkpoint(CKPT)?

4 Answers  

---

What is use of Rollback Segments In Database ?

4 Answers  

---

Diference between Oracle 9i and 10G.

2 Answers   Baidu,

---

how oracle will recognise its space is 100gb if 100gb is allocated for it...

1 Answers   Baidu,

---

How to implement the multiple control files for an existing database ?

2 Answers  

---

What is Cursor?

2 Answers   Virtusa,

---

When Does DBWR write to the database?

6 Answers  

---

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

0 Answers  

---

What is the function of Dispatcher (Dnnn)?

4 Answers  

---

How will you monitor rollback segment status ?

2 Answers  

---