What constitute an ORACLE Instance?
- 2 Answers
- 5279 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 function of Redo Log in Oracle?
What is use of Rollback Segments In Database ?
What is a Multi-threaded Server Configuration?
What is meant by redo log buffer ?
How will you monitor the space allocation ?
How to find the SGA Size
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What are the components of SGA?
How will you force database to use particular rollback segment?
Which parameter in Storage clause will reduce no. of rows per block?
How can we plan storage for very large tables ?
What is the maximum number of Lock Processes used?
Oracle General 
