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?)
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between internal & external schema?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
What is oracle log switch?
How do you set up your tablespace on installation level: low?
What are the main benefits of using spfile over pfile?
What is difference between co-related sub query and nested sub query?
How to uncatalog backup?
Explain procedure to change characterset of a database.
what does the no logging option do? Why would we use it?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
How can you determine if an index needs to be dropped and rebuilt?
What happens if the constraint name is left out of a constraint clause?