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 |
How the log writer writes the data into database
What is meant by recursive hints ?
What is an Oracle Data Dictionary?
How will you estimate the space required by a non-clustered tables?
What is the OPTIMAL parameter ?
What is Dedicated Server Configuration?
How many Dispatcher Processes are created?
What are functions of PMON?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is Cursor?
What is a Rollback segment entry ?
What is Shared Pool?