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

OS Performance Page

The operating system on the host machine provides Oracle with key resources such as CPU, memory, disk I/O, and network access. Shortfalls in any of these resources may affect the overall performance of your Oracle system.

To open the OS Performance page

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

  2. Click Operating System | OS Performance.

Tip: To open the related Spotlight on Windows or Spotlight on Unix connection, click the arrow next to the Operating System drilldown icon.

Charts on the OS Performance Page

The following charts in the OS Performance page display statistics on the operating-system resources that may cause a performance bottleneck:

Chart Description
CPU Utilization

The percentage of time spent in user mode and in privileged mode.

  • User mode is a restricted processing mode designed for applications, environment subsystems, and integral subsystems.
  • Privileged mode is designed for use by operating system components, and allows direct access to hardware and all memory.

High levels of CPU utilization may trigger the CPU Busy Alarm.

Disk I/O

The number of disk transfers per second. Disk IO bottlenecks may trigger the Free Buffer Waits Alarm or Write Complete Wait Alarm.

See also Improve Database Writer Performance and Improve Database I/O.

Note: Spotlight on Oracle does NOT display information in the Disk IO chart if the database is running on Digital Unix.

Paging and scan rates

Paging activity. This includes:

  • Pages read into memory per second.
  • Pages written out to disk per second.
  • Scan rate — the rate at which the operating system scans memory pages for candidates that can be written to disk.
Load Average/Run Queue

The length of the Processor queue where processes are waiting to be executed. Processes in this queue will run when the CPU becomes available.

A long queue may indicate that the machine you are diagnosing is under-configured for its workload. You may need to check which OS processes are consuming CPU resources. OS Processes Page

Network

The total rate of data traffic across all network interfaces, measured in packets/second. Separate graphs on the chart indicate the rates at which data packets are being:

  • Received by the host machine from the network (Packets In).
  • Transmitted by the host machine to the network (Packets Out).
Available Memory The amount of available virtual and physical memory on the database machine. A shortage in the amount of physical memory may trigger the Low Free Physical RAM Alarm.

Note: Differences between versions of operating systems mean that Spotlight is unable to collect all O/S statistics in all environments. The topic O/S statistics not reported list statistics that are not reported by Spotlight on Oracle for each operating system. Operating System Connection / Statistics

 

Related Topics

Spotlight on Oracle Drilldowns

Connection Problems | Operating System Connection / Statistics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating