System Architecture - What constitute an ORACLE Instance ?

GeekInterview.com > Interview Questions > Oracle > System Architecture

System Architecture | Question 1 of 33

What constitute an ORACLE Instance ?

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

Total Answers and Comments: 5

Last Update: October 05, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: nitanjandial

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

Above answer was rated as good by the following members:
priti2001

January 30, 2006 05:27:52

nagabhushan reddy

RE: What constitute an ORACLE Instance ?

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

January 30, 2007 18:59:52

nitanjandial

Member Since: December 2006 Contribution: 4

RE: What constitute an ORACLE 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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

March 30, 2007 18:33:56

Chiranjeevi Manne

RE: What constitute an ORACLE Instance ?

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

Is this answer useful? Yes | No

August 29, 2007 14:01:09

sushmab

Member Since: August 2007 Contribution: 1

RE: What constitute an ORACLE Instance ?

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

Is this answer useful? Yes | No

October 05, 2007 02:39:13

Mohammed Abdul Afroze

RE: What constitute an ORACLE Instance ?

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top