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?
No Answer is Posted For this Question
Be the First to Post Answer
What are the possible ways to gain information regarding the control file?
What is the main function of database?
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What does dba stand for in technology?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
What is the most common database language that a db administrator needs to know?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
How do you use automatic pga memory management with oracle 9i and above?
How can you tell if an index on particular table is used or not used in 9i?
What is end user in database?
What is a dba why is this position necessary?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?