What is the difference between Instance and a Database?

  • Interview Candidate
  • 1
  • 4304

Showing Answers 1 - 1 of 1 Answers

pkjayan

  • Apr 29th, 2007
 

Instance is the memory structures and background processes used to interact with Database.
Instance = SGA + Background Process

Database is the physical files used to store information. the 3 types of physical files are: Datafiles, Control File and Redo-Log fileS(minimum 2).
 

  Was this answer useful?  Yes

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