You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
No Answer is Posted For this Question
Be the First to Post Answer
What is tkprof and how is it used?
What is a dba why is this position necessary?
What is dump destination? What are bdump, cdump and udump?
Which process writes data from data files to database buffer cache?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
What does dba stand for in technology?
What does the no logging option do? Why would we be careful of using it?
What does a dba do all day?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
How can you find all the processes on your system?
While taking hot backup (begin end backup) what will happens back end?
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?