What is a Database instance ? Explain

 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.
  • Interview Candidate
  • 2
  • 2504

Showing Answers 1 - 2 of 2 Answers

satyam_Ora

  • Aug 17th, 2007
 

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

              

ranjanam

  • Aug 26th, 2007
 

Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions