Chat now with support
Chat with 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

I/O Segment Details - Prerequisite Steps

Before viewing I/O Segment Details, ensure you set the value of the Oracle statistics_level parameter from TYPICAL to ALL.

Note:  TYPICAL is the default STATISTICS_LEVEL setting recommended by Oracle. Setting the STATISTICS_LEVEL parameter to ALL instructs Oracle to collect additional information on timed OS statistics and plan execution statistics. This information is gathered (by default) every 5 seconds, and can add significantly to the target system's CPU usage and system load.

How to set the value of the Oracle statistics_level

  1. Open the Configuration & Memory | Oracle Parameters Page.
  2. In the Oracle Parameters grid, right-click the statistics_level row, and select Modify parameter.
  3. Enter the value ALL in the Parameter value field, and choose a desired value for the scope field. (For more information, see the Oracle Parameters Page.)
  4. Click Update.
  5. Close and restart Spotlight, and return to the I/O | Segment Page.
  6. Click a segment in the Segment table to open I/O Segment Details.

 

Related Topics

Spotlight on Oracle Drilldowns

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating