Answer / madhusmita dash

Oracle architecture is the combination of SGA,Background
Processes,PGA,Physical files like redo log files,control
files,data files etc.These are most important part of the
oracle architecture.

Answer / charvi

Architecture describes in terms of phycical and logical structure.
Physical--CRD files,Loigal FIles--Tablespace.

Instance:Collection of System Global Area and Background Process.

System Global Area: It Consists of Several Memory structures.
1) Library Cache 2) Data Dictionary Cache 3) Data Buffer Cache $) Redo Buffer Cache 5) Java pool,Large Pool,Stream Pool.

Background Process:
1)Process Monitor(PMON) 2) system Monitor(SMON) 3)Data Base Writer(DBWR) 4)Log Writer(LGWR) 5)Check Point.

Database: The Collection of Control file,Database file,Redo log File.

Answer / akhilesh kumar

please give me answer

What is Server Process?

2 Answers  

---

What is the maximum size of a row in oracle 9i?

4 Answers   Baidu, HCL, Yashu Systems,

---

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  

---

How will you create multiple rollback segments in a database ?

1 Answers  

---

Why query fails sometimes ?

1 Answers  

---

How many Dispatcher Processes are created?

1 Answers  

---

What are disadvanteges of having raw devices ?

1 Answers  

---

What is use of Rollback Segments In Database ?

4 Answers  

---

What is PGA?

5 Answers  

---

What is SGA?

3 Answers  

---

Teradata: How can we know the indexed column in a table?

0 Answers   CTS, HSBC,

---

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

1 Answers   Baidu,

---