GeekInterview.com
   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  >  Database Administration

 Print  |  
Question:  
What is a Database instance ? Explain

Answer:
 
A  database  instance  (Server) is a set of memory structure and background processes that access a set of database files.
 
The process can be shared by all users.
 
The  memory  structure  that  are  used  to  store  most  queried data from database.  This  helps up to improve database performance by decreasing the amount of I/O performed against data file.


August 08, 2007 21:10:04 #1
 satyam_Ora   Member Since: July 2007    Total Comments: 28 
RE: What is a Database instance ? Explain
 

A database instance also know as server is a set of memory structures and background processes that access a set of database files.It is possible for a single database to be accessed by multiple instances (this is oracle parallel server option).

         Instance 1  <->    datafiles <->          Instance 2

              

     

 

Back To Question