Chat now with support
Chat with Support

Spotlight on Oracle 10.8 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating