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

How to use null as conditions in oracle?

665


How to set up autotrace for a user account?

675


How can Oracle users be audited?

701


Explain the use of compress option in exp command.

628


What are the roles of dba?

704






How do I spool to a csv formatted file using sqlplus?

619


How to name query output columns in oracle?

794


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2166


How do I use unicode codesets with the weblogic jdriver for oracle driver?

640


How do I learn what codesets are available in oracle?

659


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1529


Explain overloading. Can functions be overloaded?

649


What is the difference between pre-select and pre-query?

713


How to install oracle odbc drivers?

707


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

631