Answer Detail: RE: What constitute an ORACLE Instance ?

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.

June 06, 2009 01:06:41	#6
nareshkumarmca	Member Since: February 2009 Total Comments: 3
RE: What constitute an ORACLE Instance ?
Oracle instance is the combination of SGA and background processes. When user sends a connection request server process starts and it starts instance.