Oracle System Architecture Question:

Download Job Interview Questions and Answers PDF

Explain what constitute an ORACLE Instance?

System Architecture Interview Question
System Architecture Interview Question

Answer:

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

Download System Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me what are the functions of SMON?Tell me what does LGWR do?