Database Administration Question:
Explain What is a database instance?
Answers:
Answer #1A 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.
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.
Answer #2Instance is a collection of sga and background process.It is shared by all the application users. When instance start at that time oracle reads the parameter file from $ORACLE_HOME/dbs location so sga is allocated and background process start.
| Previous Question | Next Question |
| What are the types of synonyms in Oracle? | Explain Can we decrease the Datafile size? |