Interested to Buy Any Domain ? << Click Here >> for more details...
What constitute an ORACLE Instance?
- 2 Answers
- 6244 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / cspriyadba
Oracle Instance constits of on
Memory Structure and Background Process
* Memory structure constists of SGA and PGA
=>SGA constists of
1)Shared Pool
2)Database Buffer Cache
3)Redo log Buffer
4)Java Pool
5)Large Pool
=>PGA constists of
1)Server Process
2)User Process
* Background Process constists of
1)PMON
2)SMON
3)DBWR
4)LGWR
5)CKPT
6)Others
and optional Bg process also there
RECO,QMNn,ARCn,LCKn,LMDn,Snnn,Pnnn etc..
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / siva.k
SGA and ORACLE background processes constitute an ORACLE
instance.
(or)
Combination of memory structure and background process.
| Is This Answer Correct ? | 3 Yes | 0 No |
How to implement the multiple control files for an existing database ?
How does Space allocation table place within a block ?
What is function of RECO?
What are the two types of Server Configurations?
What is SGA?
What are the components of SGA?
What is Shared SQL Area?
What is an Oracle SYSTEM tablespace and when is it Created?
What is the function of Lock (LCKn) Process?
what is ORACLE MEMORY STRUCTURES
What Does DBWR do?
How can we plan storage for very large tables ?
Oracle General 
