What constitute an ORACLE Instance ?

SGA  and  ORACLE  background  processes constitute an ORACLE instance. (or) Combination of memory structure and background process.

Showing Answers 1 - 17 of 17 Answers

nagabhushan reddy

  • Jan 30th, 2006
 

when database  started on oracle server an oracle allocates a memory called SGA and some back ground process. The combination of SGA and back ground process is called instance.

it's made up of Memory Structure and Blackground ProcessesMemory Struture(In oracle SGA(system global area))SGA consists of several memory areamandatory memory area1.shared pools=libary+data dictionary cache2.database buffer cache3.redo log bufferOptional1.large pool2.jave poolBACKGROUND Process(mandatory)1.smon(system monitor)2.pmon(process monitro)3.ckpt(check point)4.dbwr(database writer)5.lgwn(log writer)pls correct me,if i miss any point

Chiranjeevi Manne

  • Mar 30th, 2007
 

An oracle instance is a combination of Memory structures along with a set of Background processes.
The typical background processes are

DBWR, LGWR, CKPT, ARCH, PMON, SMON, MMON etc ..

  Was this answer useful?  Yes

sushmab

  • Aug 29th, 2007
 

An Oracle instance is combination of the background processess and memory structure. The Instance must be started to access the data in the database.

  Was this answer useful?  Yes

Mohammed Abdul Afroze

  • Oct 5th, 2007
 

A system Global Area and Oracle Background Processes together consitute an Instance.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions