What is tkprof and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
Tell me about standby database? What should we watch out for?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
Explain the wait events in statspack report 'db sequential real'?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
What is oracle log switch?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
What are the types of locks in database?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
What are the steps involved in instance recovery in oracle?
How can you determine the space left in a file system?
What is different type of rman backup?
How many control files should you have? Where should they be located?