RelationalDBDesign
SiteMap
Advanced Tuning
SQL Tuning
Perform Tuning
Tuning Instance
Tuning Basics
External Environment
Data Dictionary
«Prev
Next»
Performance Tuning
Data Blocks
Database Block Size
Oracle Block Buffers
Index Scan
Min Block Size
Optimizing Space Usage
Segment Header Internals
Segment Header Control
Manage Free Space
Data Block Fundamentals
PCtfree Optimal Performance
Migrated Chained Rows
Migrating Chaining Rows
Oracle Table Statistics
PCtused Optimal Performance
PCT Used Optimal Performance
PCT Used Performance
Setting PCT Used Guidelines
Monitoring Tuning Indexes
Monitoring Tuning Indexes
Analyzing Oracle Index
Table High Water Marks
High Water Mark
Water Mark Active
DB Engine Conclusion
Data Structures
Oracle Structures
Object Oriented Database
Abstract Data Types
Using Oracle Objects
Oracle nested Tables
Oracle Varrays
Performance Conclusion
Data Dictionary
Oracle Data Dictionary
Sending DBA Alert Output
Partitioned Tuning
DBA Tab Partitions View
Partitioned Index Maintenance
Data Base Objects
DBA Partition Views
Index Techniques
Tuning with Indexes
Bitmap Indexes
b-tree Indexes
Oracle Bitmap
Increase Query Speed
Speed up Queries
Oracle Bitmap Response
DW Star Schema
Star Schema
Star Query Process
Star Transformation Queries
Requirements for Star Trans
Star Query vs. Transformation
Star Transformation Process
Transformation Process
Transformation Steps
Using Concatenated Indexes
Appropriate Oracle Indexes
Function Based Indexes
Bitmapped Indexes
Oracle Database Tuning
Oracle Web Applications
Web Request Broker
Oracle Tuning - Glossary
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.
Submit
x