What is a database instance. Explain

bhavana · 23-01-07, 06:09 PM

What is a database instance and Explain <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

ajithcharles · 26-01-07, 08:51 PM

The processes involved to bring a database into full functional mode are
1) Start the instance
2) Mount the database
3) open the database

Starting the instance implies creating the SystemGlobalArea along with initializing and allocating memory for the buffers.

sriodba · 09-02-08, 03:14 AM

hi
DB Instance is the s/w and memory (ram) that are used to manipulate data in the DB. memory=SGA

PrashanthU · 09-02-08, 12:25 PM

Bhavana,

A database instance is a combination of background services or programs along with memory buffers ( SGA - System Global Area - It is an area of memory used for database information shared by database users)

Thanks,
Prashanth

mymailbox.21 · 13-03-08, 05:19 PM

hi database instance is a mean to access the data from the database.

23-01-07, 06:09 PM	#1 (permalink)
bhavana Senior Member Join Date: Jan 2007 Posts: 598 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 7	What is a database instance. Explain What is a database instance and Explain <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>

26-01-07, 08:51 PM	#2 (permalink)
ajithcharles Senior Member Join Date: Mar 2006 Age: 24 Posts: 343 Thanks: 3 Thanked 12 Times in 12 Posts Thanks: 3 Thanked 12 Times in 12 Posts Rep Power: 8	Re: What is a database instance and Explain The processes involved to bring a database into full functional mode are 1) Start the instance 2) Mount the database 3) open the database Starting the instance implies creating the SystemGlobalArea along with initializing and allocating memory for the buffers. __________________ JSP,Oracle,SQL : http://mycodesnippetjsp.blogspot.com/ Complete List :http://www.blogger.com/profile/04567238067268200918

09-02-08, 03:14 AM	#3 (permalink)
sriodba Junior Member Join Date: Feb 2008 Age: 28 Posts: 8 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What is a database instance. Explain hi DB Instance is the s/w and memory (ram) that are used to manipulate data in the DB. memory=SGA

09-02-08, 12:25 PM	#4 (permalink)
PrashanthU Senior Member Join Date: Jan 2007 Age: 27 Posts: 103 Thanks: 0 Thanked 7 Times in 5 Posts Thanks: 0 Thanked 7 Times in 5 Posts Rep Power: 4	Re: What is a database instance. Explain Bhavana, A database instance is a combination of background services or programs along with memory buffers ( SGA - System Global Area - It is an area of memory used for database information shared by database users) Thanks, Prashanth __________________ " Success Is Not Measured By What One Has Achieved, But What One Has Achieved, Compared To What One Is Capable Of " Keep Smiling :-)

13-03-08, 05:19 PM	#5 (permalink)
mymailbox.21 Junior Member Join Date: Mar 2008 Age: 25 Posts: 28 Thanks: 0 Thanked 0 Times in 0 Posts Thanks: 0 Thanked 0 Times in 0 Posts Rep Power: 1	Re: What is a database instance. Explain hi database instance is a mean to access the data from the database.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
interview Q&A asked in winrunner	Spoorthi	Testing Tools & QA	80	22-11-08 11:48 PM
Explain the relationship among Database, Tablespace and Data file.	bhavana	Oracle Interview / Technical Questions	0	23-01-07 05:58 PM
What is a Database instance ? Explain	bhavana	Oracle Interview / Technical Questions	0	23-01-07 02:09 PM
Database Engineer with 2-4 Years Exp - Noida	sridhar	EXPERIENCED JOBS	2	05-09-06 10:20 PM
regarding oracle versions	Madhuri	ORACLE , SQL SERVER , SYBASE & Others	7	07-07-06 07:06 PM