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 skills do you need to be an administrator?
What is oracle archived redo log?
Who is a database user?
What is oracle log switch?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What do you understand by the term 'normalization'? Explain the various modes of normalization?
Which date function is used to find the difference between two dates?
What does a senior database administrator do?
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 is a dba why is this position necessary?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?