High Water Mark
Oracle Segment Header Internals
PCtfree Optimal Performance
PCtused Optimal Performance
Water Mark Active
Object Oriented Database
Abstract Data Types
Oracle Data Dictionary
Sending DBA Alert Output
DBA Tab Partitions View
Partitioned Index Maintenance
Data Base Objects
DBA Partition Views
Star Query Process
Function Based Indexes
Using Concatenated Indexes
Oracle Database Tuning
Customizing DBA Performance - Exercise
Using the V$ views
Write an SGA snapshot routine using the V$ views.
This exercise is worth a total of 10 points. Once you have completed your answer you will submit your answer.
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 ??? ;
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.
button to submit the code .
To make the exercise more challenging, try to display the sort ratio by joining V$SYSSTAT against itself.