Interested to Buy Any Domain ? << Click Here >> for more details...
What is explain plan and how is it used?
- 0 Answers
- 609 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
What is a database instance?
What should a dba know?
Explain the wait events in statspack report 'enqueue'?
What is end user in database?
How can you determine if an index needs to be dropped and rebuilt?
How many redo logs should you have and how should they be configured for maximum recoverability?
List five most important parameter in 9i affecting performance?
What are the different responsibilities of a dba?
What is the difference between a database and instance? What is the relation between them?
What is pga_aggregate_target?
Oracle General 
