Answer Detail: RE: What constitute an ORACLE Instance ?

Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question

GeekInterview.com > Interview Questions > Oracle > System Architecture

Print |

Question:

What constitute an ORACLE Instance ?

Answer:

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

January 01, 2007 18:59:52	#2
nitanjandial	Member Since: December 2006 Total Comments: 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

Back To Question