GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  Database Administration
Go To First  |  Previous Question  |  Next Question 
 Database Administration  |  Question 50 of 231    Print  
What is a database instance and Explain

  
Total Answers and Comments: 3 Last Update: July 10, 2009   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 19, 2005 05:53:19   #1  
Suresh        

RE: What is a database instance and Explain
A instance is basically a set of memory and some background processes.
 
Is this answer useful? Yes | No
January 04, 2006 03:29:31   #2  
cmanne Member Since: January 2006   Contribution: 49    

RE: What is a database instance and Explain
An Oracle instance is a combination of background processes and memory structures (SGA)
 
Is this answer useful? Yes | No
July 10, 2009 02:12:53   #3  
imran44 Member Since: December 2008   Contribution: 12    

RE: What is a database instance and Explain
SGA+Background Process Instance

As soon as user process starts and server process takes control from user process instance created with help of background processes and most important background processes are dbwriter logwriter checkpoint SMON PMON and components of SGA are shared pool database buffer cache redo log cache large pool stream pool.

Most important library cache + Data Dictionary Shared Pool

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape