Interested to Buy Any Domain ? << Click Here >> for more details...
What constitute an ORACLE Instance?
- 2 Answers
- 6251 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 |
When Does DBWR write to the database?
What is a Parallel Server option in ORACLE?
• What is oracle Architecture?
How can you find the size of a database?
what is the role of archiever
What is Shared Pool?
What are Oracle Schema Objects?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the function of Dispatcher (Dnnn)?
What do Redo Log Buffers contain?
Which parameter in Storage clause will reduce no. of rows per block?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
Oracle General 
