When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?

Question Posted / alok kumar

No Answer is Posted For this Question
Be the First to Post Answer

More Oracle DBA (Database Administration) Interview Questions

What are elements of administration?

Discuss row chaining, how does it happen?

What are the goals of dba?

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

If you see contention for library caches how you can fix it?

While taking hot backup (begin end backup) what will happens back end?

What is the difference between raid 5 and raid 10? Which is better for oracle?

What are the requirements of simple database?

Which date function is used to find the difference between two dates?

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

What is a dba why is this position necessary?

How do you analyze table partition using oracle provided package?

For more Oracle DBA (Database Administration) Interview Questions Click Here