Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 11.0 - 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 RAC 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
Instance name The instance in the Oracle RAC cluster where the session is connected.

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

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione