Interested to Buy Any Domain ? << Click Here >> for more details...
What constitute an ORACLE Instance?
- 2 Answers
- 6403 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 |
what is the role of archiever
How the space utilisation takes place within rollback segments?
What is User Process?
What is the significance of having storage clause ?
What is use of Rollback Segments In Database ?
What is hit ratio ?
What is Dedicated Server Configuration?
What does LGWR do?
What is an Oracle Data Block?
Name the ORACLE Background Process?
What is PGA?
What is an Oracle Data Segment?
Oracle General 
