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 |
Which parameter in Storage clause will reduce no. of rows per block?
What is an Oracle Data Segment?
What is User Process?
What Does DBWR do?
How the space utilisation takes place within rollback segments?
How will you estimate the space required by a non-clustered tables?
Can a Tablespace hold objects from different Schemes in Oracle?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What are disadvanteges of having raw devices ?
How many Dispatcher Processes are created?
What is function of RECO?
What is Shared Pool?