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.

nitanjandial

 Profile Answers by nitanjandial 

• Jan 30th, 2007

 

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 ..

sushmab

 Profile Answers by 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.

Mohammed Abdul Afroze

• Oct 5th, 2007

 

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

nareshkumarmca

 Profile Answers by nareshkumarmca 

• Jun 19th, 2009

 

Oracle instance is the combination of SGA and
background processes.
When user sends a connection request server process starts and it starts instance.

dj_dj_dj

 Profile Answers by dj_dj_dj 

• Jun 22nd, 2009

 

Oracle Instance is an combination of background process and memory structures.