What is tkprof and how is it used?
No Answer is Posted For this Question
Be the First to Post Answer
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
What degree do database administrators need?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
If you see statistics that deal with "undo" what are they really talking about?
What does an oracle dba do?
What is the most common database language that a db administrator needs to know?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
You see multiple extents in the temporary tablespace. Is this a problem?
What is the difference between cold backup and hot backup?
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?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
How do you analyze table partition using oracle provided package?