What is the relation between database and instance?
- 1 Answers
- 748 Views
- I also Faced
- E-Mail Answers
Answer / Krishna Kant Sharma
The Oracle Database and Instance are two different but closely related components of an Oracle database system. The database is a collection of data structures storing information, while the instance is the actual software that manages the database, including processes, memory structures, and background processes. In other words, an instance runs on one or more computer systems to support one or more databases.
| Is This Answer Correct ? | 0 Yes | 0 No |
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
What are the types of locks in database?
Discuss row chaining, how does it happen? How can you reduce it?
What do you mean by oracle dba and what is its role?
You see multiple extents in the temporary tablespace. Is this a problem?
What happens when the default and temp tablespace clauses are left out from create user statements?
What is the easiest method to create a file on unix?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
How much money does a dba make?
List five most important parameter in 9i affecting performance?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
Oracle General 
