This exercise is worth a total of 10 points. Once you have completed your answer you will submit your answer.
Background and Overview
You suspect that your database is suffering from too many disk sorts, for instance sort_area_size too small. You have decided that a script that interrogates V$SYSSTATwould give you the total number of memory sorts, and the total number of disk sorts.
'sorts (memory)'
'sorts (disk)'
select
???
???
from
V$SYSSTAT
where
???
;
Instructions
Given the information above, rewrite this script to query the V$SYSSTAT view, and gather the required information.
The columns for the sort value columns all begin with 'sort:
- Submitting your Exercise: Enter your answer into the text box below. Click the Submit button to submit the code .
- Hints: To make the exercise more challenging, try to display the sort ratio by joining V$SYSSTAT against itself.