Topic : Instance

What is a database instance?


Answer :

A database instance is a set of memory structure and background processes that access a set of database files. The processes can be shared by all of the users.

Show Answer Discuss

What is an SID?


Answer :

The SID is the system identifier. This environment variable is used to determine which database to connect to.

Show Answer Discuss

What is the bootstrap instance?


Answer :

This is the instance that is created under NT with the NT Instance Manager or with ORADIM80.EXE. This service allows you to start and stop the Oracle instance via the Oracle tools.

Show Answer Discuss

Can you have more than one instance on a system?


Answer :

Yes; the Oracle RDBMS supports more than one instance running on a server.

Show Answer Discuss