What is a Database instance ? Explain?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nishi
A database instance is a set of memory structures that manage database files. A database is a set of physical files on disk created by the CREATE DATABASE statement. The instance manages its associated data and serves the users of thedatabase.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna mohan mishra
The database instance refers to a complete database
environment. It includes RDBMS software, table structure,
stored procedures and other functions. It is normally used
when administrators tend to describe multiple instances of
the same database. It is also called as environment in
technical terms.
---Krishna Mohan Mishra
Is This Answer Correct ? | 1 Yes | 2 No |
What are the oracle differences between nvl and coalesce
How can I get column names from a table in oracle?
What is Index and different types of Indexes?
Explain the use of online redo log files in oracle.
How to pass a parameter to a cursor in oracle?
structural difference between bitmap and btree index ?
who is the father of oracle and send chodd rules
Explain the concept of the DUAL table.
How to rename a column in an existing table?
How to define an oracle sub procedure?
How to pass parameters to procedures?
What is private procedure oracle?