Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - 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 Spotlight on MySQL Troubleshooting: Connection Problems

System Calls Page

A system call is a library function that requests a service from the operating system. This page shows information about the system calls that Oracle makes to the Solaris operating system.

To open the System Calls Page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click DTrace | System Calls.

Notes:

  • Before you can capture the details of the interaction between Oracle and a Solaris operating system, you need follow some configuration steps. Install And Configure DTrace Scripts
  • When you open this page Spotlight launches a query to collect the relevant operating system data. Initially, Spotlight may take some seconds to return the required data.
  • When you have started one of the DTrace queries, it will keep running until you close the Spotlight connection.

Charts on the System Calls Page

Chart

Description

Oracle System Call Rate

In this filtered chart, Spotlight shows the rate of system calls for the Oracle executable.

The Y-axis of the chart displays the system calls in order of popularity — the types of calls performed most often appear at the top of the chart.

Tips:

  • We have compiled a page listing some system calls commonly used by Oracle processes. Common Solaris system calls Descriptions for these and other Solaris system calls can be obtained via the Unix man or whatis commands.
  • For more information on system calls, see System Calls or visit sites such as the Oracle Solaris web site.
Oracle System Call CPU Times

In the filtered Oracle System Call CPU Times chart, Spotlight shows the rate (in milliseconds per second) at which time is spent performing the various types of system calls for the Oracle executable.

The Y-axis in this chart does not display system calls in the same order as the Oracle System Call Rate chart — the time spent performing a type of call is the product of that call type's call rate and the average duration of a single call.

Note: The aggregated CPU time for ALL system calls cannot exceed (1000 ms/s) x (the number of CPUs on the server).

Grid on the System Calls Page

Oracle System Calls displays the information collected by Spotlight on the system calls that Oracle makes to the Solaris server.

Notes:

  • Descriptions for system calls can be obtained by using the Unix man or whatis commands. Some man entries may vary slightly from the DTrace listing. For instance, the man page for pollsys is "man poll"; the man page for read64 is "man read".
  • The Spotlight query used to populate the System Calls page starts when you open the page and continues until the end of the Spotlight connection, so times shown in this table represent times since the query started.

Column

Description

System Call

The type of system call.

Calls/sec

The number of system calls of the specified type performed per second.

CPU Time (ms)

The total amount of CPU time spent on this type of system call.

[The aggregated CPU time for ALL system calls cannot exceed (1000 ms/s) x (the number of CPUs on the server).]

CPU Rate (ms/s)

The proportion of CPU time spent on this type of system call.

Avg CPU/Call (μs)

The average amount of CPU time spent on each call of the specified type, measured in microseconds.

Pct CPU

The percentage of CPU time spent in performing the specified type of system call.

Elapsed (ms/s)

The total elapsed time spent on this type of system call.

[Elapsed time includes wait time, and does not have the same limitations as CPU time. Theoretically, since ALL system calls may be waiting at the same time, the aggregated elapsed time can be as much as (1000 ms/s) x (the number of system calls).]

Avg Elapsed Time (μs)

The average amount of elapsed time spent on each call of the specified type, measured in microseconds.

Calls

The total number of calls of the specified type that have been made since the Spotlight query was started.

Total Time (ms)

The total elapsed time spent performing the specified type of system call.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating