What constitute an ORACLE Instance?
- 2 Answers
- 5718 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 maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
How to find the current session sid
When Does DBWR write to the database?
What is Dedicated Server Configuration?
What is an oracle database schema?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
• What is oracle Architecture?
what is ORACLE MEMORY STRUCTURES
What is dictionary cache ?
What is PGA?
What is meant by recursive hints ?
What is an Integrity Constrains in Oracle?
Oracle General 
