What is tkprof and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
What is dba software?
List five most important parameter in 9i affecting performance?
Discuss row chaining, how does it happen? How do you correct it?
How do you analyze table partition using oracle provided package?
How do you set up tablespaces during an oracle installation?
What file will give you oracle instance status information? Where is it located?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
When using oracle export/import what character set concerns might come up? How do you handle them?
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?)
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
Users are not being allowed on the system. The following message is received: ora-00257 archiver is stuck. Connect internal only, until freed. What is the problem?
What parameters control copy latches?