InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When Looking At V$sysstat You See That Sorts (disk) Is High. Is This Bad Or Good? If Bad, How Do You Correct It? |
|
Answer» If you GET excessive DISK sorts this is BAD. This indicates you need to tune the sort area PARAMETERS in the initialization files. The major sort are parameter is the SORT_AREA_SIZe parameter. If you get excessive disk sorts this is bad. This indicates you need to tune the sort area parameters in the initialization files. The major sort are parameter is the SORT_AREA_SIZe parameter. |
|