Interested to Buy Any Domain ? << Click Here >> for more details...
• What is oracle Architecture?
- 3 Answers
- 6314 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 15 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the consideration at tehe migration of Oracle 9i to 10G.
What is the function of Dispatcher (Dnnn)?
When will be a segment released?
What do Redo Log Buffers contain?
What is advantage of having disk shadowing/ Mirroring ?
What is a Multi-threaded Server Configuration?
What constitute an ORACLE Instance?
How can we plan storage for very large tables ?
• What is oracle Architecture?
List the factors that can affect the accuracy of the estimations ?
Why query fails sometimes ?
How will you estimate the space required by a non-clustered tables?
Oracle General 
