Chat now with support
Chat mit Support

Spotlight on Oracle 10.10 - 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 Troubleshooting: Connection Problems

Sessions Page

Shows user sessions where sorting may be a problem.

To open the Sessions page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.

  2. Click SQL & Application Workload | Sort Activity Page | Sessions.

Top Sessions by Sort Activity Grid

Problem sessions may have the largest values for:

  • Temp File Reads: This column shows which sorts have the highest number of multi-pass operations.
  • Sorts Disk and Sorts Memory: This column indicates where sorts are performed. Disk sorts are the most wasteful.
  • Multipass Sorts: The most wasteful type of disk sorts.

When you identify a problem session you may decide to kill it:

  1. Double click on the session to open the Top Sessions Page.
  2. On the Top Sessions page, right-click the problem session and select Kill/Disconnect Session. Top Sessions Page
Column Description

SID

Session ID of the connected session.

Oracle User

The user running the session.

Program

The program running in the session.

Module

The active module within the program.

Sorts Memory

The number of sorting operations performed ONLY in memory. These are the most efficient sorts, as they require no I/O access to disk.

Sorts Disk

The number of sorting operations that require at least one I/O operation to disk. These may be one-pass OR multi-pass sorts.

Rows Sorted

The number of rows sorted while executing SQL statements during the session.

Temp File Reads

The number of times that data has been read from disk during the session.

Temp File Writes

The number of times that data has been written to disk during the session.

Optimal Sorts

The number of times within the session that sorting has been performed entirely in memory.

Onepass Sorts

The number of times within the session that sorting has been performed with a single I/O operation to disk.

Multipass Sorts

The number of times that within the session that sorting has been performed with multiple I/O operation to disk.

Machine

The machine where the session originated.

OS User

The O/S user that initiated the session.

Note: The metrics in the Top Sessions by Sort Activity table are derived from data collected from V$SESSTAT.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen