Tchater maintenant avec le support
Tchattez avec un ingénieur du support

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

Oracle Top Sessions

To improve performance, Spotlight on Oracle retrieves only changed session details in the Top Sessions drilldown. Disconnected sessions may continue to be displayed until a cleanup occurs. A cleanup occurs every five minutes by default.

Cleaning up more frequently reduces the chance that disconnected sessions will be displayed. However, it may result in reduced performance and increased system overhead, especially on systems with hundreds of users.

To change the Top Sessions reset interval

  1. Open a Spotlight on Oracle connection.
  2. Select View | Options.
  3. Click Appearance | Oracle Top Sessions.
  4. Configure the following options
Option Description
Always reset Top Sessions Performs a full refresh of the Top Sessions window each time the window is refreshed. The refresh rate is set in Spotlight Options | Data Refresh Rates.
Reset Top Sessions every xxx minutes Performs a full refresh of the Top Sessions window at the interval you enter in the selection box. You can type or select values from 1 to 999 minutes.
Display only active sessions

Select this option to improve Spotlight's performance by displaying only active sessions in the Top Sessions Page.

The active status of sessions is determined from several Top Sessions metrics (such as those related to CPU usage and log reads).

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation