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 explain compound trigger in oracle?
How index is implemented in oracle database?
What is the difference between sharding and partitioning?
What is the difference between substr & instr functions?
What is a view and how is it different from a table?
How to divide query output into groups in oracle?
How do I find the database name in oracle?
How to export several tables together?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the sql query to concatenate column values from multiple rows in oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
What's dateware house and what's clustor with practicle example
What is bulk copy or bcp in oracle?
How to view the tablespaces in the current database?
Is it possible to split the print reviewer into more than one region ?
