Data Dictionary   «Prev  Next»

Customizing DBA Performance - Exercise

Using the V$ views

Objective:Write an SGA snapshot routine using the V$ views.

Scoring

This exercise is worth a total of 10 points. Once you have completed your answer you will submit your answer.

Background/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.