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
Explain an index segment?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
types of indexes and the rationale behind choosing a particular index for a situation.
Explain the use of analyse option in exp command.
What is SQL access advisor in Oracle?
What is the difference between a hot backup and a cold backup in oracle?
What is java oracle used for?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Explain the use of inctype option in exp command.
How to define a specific record type?
What is ASM (Automatic Storage Management) in Oracle?
What is a trigger oracle?
Explain oracle’s system global area (sga).
what is the use of system.effective.date variable in oracle?
How to connect to the server with user account: sys?
