What constitute an ORACLE Instance?
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 does LGWR do?
What is advantage of having disk shadowing/ Mirroring ?
What is meant by recursive hints ?
1.Explain the three levels with the help og a diagram.
What is an Integrity Constrains in Oracle?
How will you force database to use particular rollback segment?
Can a View based on another View in Oracle?
What is User Process?
What constitute an ORACLE Instance?
How the space utilisation takes place within rollback segments?
How will you create multiple rollback segments in a database ?
What is Shared SQL Area?