Chat now with support
Chat mit Support

Spotlight on Oracle 10.4 - Release Notes

Sorts Page

The Sorts page provides details on the rate at which tables are sorted in the database under investigation.

To open the Sorts page

  1. Select the Spotlight on MySQL connection in the Spotlight Browser.
  2. Click Activity | Sorts.

Charts on the Sorts page

Chart Description

Sorts per Second chart

This chart shows sort rates for the current Spotlight on MySQL connection.

Data Series Description

Total Sorts

The rate at which all sorts were performed in the displayed period, measured in sorts per second.

Range Sorts

The rate at which sorts were performed with ranges in the displayed period.

Scan Sorts

The rate at which sorts were performed by scanning tables in the displayed period.

Sort Rows per Second

This chart shows the rate at which rows were sorted in the displayed period.

Sort Merge Operations per Second

This chart shows the rate at which merge sorts were performed in the displayed period.

A sort merge breaks a large table into a series of smaller temporary tables, sorts each temporary table independently, and then merges the sorted results back into the original table.

Merges per Sort

This chart shows the average number of merge passes required to complete a sort merge.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen