立即与支持人员聊天
与支持团队交流

Spotlight on Oracle 10.10 - Release Notes

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级