What is a Database instance ? Explain?

Answer Posted / sawant

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.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are synonyms used for?

826


How to set up autotrace for a user account?

807


Explain an integrity constrains?

906


What is Java Pool in Oracle?

858


How to speed up webrick?

854


How to create a stored procedure in oracle?

812


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2233


Why does for update in oracle 8 cause an ora-01002 error?

765


Point the difference between translate and replace?

852


What are the restrictions in a oracle read only transaction?

786


Can we write dml statement in function in oracle?

845


How to insert a new row into a table in oracle?

866


Is there an oracle sql query that aggregates multiple rows into one row?

795


interview questions with answer for cts

2349


Design database draw er diagram for a certain scenario ?

4335