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
How to set a transaction to be read only in oracle?
How to estimate disk space needed for an export job?
What is Java Pool in Oracle?
What is Redo Log Buffer in Oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Why does Oracle not permit the use of PCTUSED with indexes?
Explain a segment?
How many types of cluster table in Oracle?
What are the predefined tablespaces in a database?
How many categories of data types?
What is difference between cartesian join and cross join?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What are the differences between char and nchar in oracle?
Explain an index segment?
How to run create database statement?