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

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

1 Answers  

---

When does LGWR write to the database?

3 Answers  

---

What is the OPTIMAL parameter ?

1 Answers   TCS,

---

What constitute an ORACLE Instance?

2 Answers  

---

How the space utilisation takes place within rollback segments?

2 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 a Parallel Server option in ORACLE?

1 Answers  

---

What is Server Process?

2 Answers  

---

What is a Multi-threaded Server Configuration?

1 Answers  

---

What is SGA?

3 Answers  

---

What is a Rollback segment entry ?

3 Answers   TCS,

---

How does Space allocation table place within a block ?

1 Answers  

---