지금 지원 담당자와 채팅
지원 담당자와 채팅

Spotlight on Oracle 10.4 - 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

Summary Page

Use the Summary page to monitor types of I/O activity on the database and view I/O behavior that may cause problems in database performance.

To open the Summary page

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

  2. Click I/O | Summary.

Category?

Use Category to choose how to view I/O activity on the monitored database.

Category Description

Consumer Group

A resource consumer group is a group of user sessions that have a common set of processing needs.

Oracle provides some consumer groups that cannot be modified or deleted. A database administrator can add new groups, switch sessions between groups, and set up mapping rules for assigning new user sessions automatically to a consumer group.

Note: Valid only for active resource plans.

Note: Available for Oracle 11g and later.

File Type

File Type groups I/O activity by the files on which I/O operations are performed.

Function

Function groups I/O activity by application or job for subgroups such as background processes, types of activity, and types of I/O.

Note: Available for Oracle 11g and later.

Wait Type

The default Wait Type category groups I/O according to the types of I/O performed.

Throughput - requests Chart

Throughput—Requests charts the rate of I/O requests according to the category selected. As the number of requests approaches the limit of the I/O system being used for the database, latency will start to degrade.

Values that are consistently high over the displayed period are those most likely to contribute to performance bottlenecks.

  • For Consumer Group, File Type, and Function, throughput is measured by the number of physical I/O requests per second.
  • For Wait Type (the default), throughput is measured in waits per second for each wait type.
Category Description

Consumer Group

The data series in the chart are derived from V$RSRC_CONSUMER_GROUP, and show the rates of I/O requests for an active consumer group on the database.

Note: Valid only for active resource plans.

Note: Available for Oracle 11g and later.

File Type

(Oracle 11g and later) The data series in the chart are derived from V$IOSTAT_FILE and show the rates of I/O requests for types of files in the database.

(Oracle 10g) The data series are derived from V$FILESTAT and V$TEMPSTAT.

Function

The data series in the chart are derived from V$IOSTAT_FUNCTION, and show the rates of I/O requests for applications or jobs on the database.

Note: Available for Oracle 11g and later.

Wait Type

The default Wait Type category groups I/O requests according to the types of I/O performed on the database. Spotlight generates the data series in this chart from information in V$SYSTEM_EVENT.

(See also Activity | Summary PageEvent Waits Chart.)

Throughput - transfer rate (by File Type) Chart

For the category selected, Throughput—Transfer Rate shows (in MB/s) the rates at which data moves through the I/O subsystem.

View the data in this chart and compare each data series to the corresponding series in Throughput—Requests. (A high number of requests, but a low transfer rate could indicate a lot of single block reads. If the transfer rate is approaching the limit of the I/O system, this could cause a performance bottleneck.)

Notes:

  • Oracle does not provide information on transfer rates against wait types, so if you choose Wait Type from the Category, the Throughput—Transfer Rate chart displays throughput by function instead of throughput by wait type.
  • (Oracle 10g) For the File Type category, the Throughput - Transfer Rate chart shows no data for the control file and log file.
  • The Consumer Group and Function categories are valid only for (Oracle 11g and later) (and Consumer Group only for active resource plans).

Latency Chart

For the category selected, Latency shows the average time delay experienced while the database performs different types of I/O activities.

Values that are consistently high over the displayed period are those most likely to contribute to performance bottlenecks.

  • For Consumer Group, File Type, and Function, latency is the average time (in milliseconds) taken to process a physical I/O request.
  • For Wait Type (the default), latency is the average time (in milliseconds) taken to process a wait event.

To maximize response time to end users, the latency should remain low – in general a latency below 10ms will give users good response time. As the latency increases, the response time may degrade. This time will vary from database to database – for example in a large batch job – the latency might not be as important as the throughput, but when there is a lot of users on the system, a low latency is important to ensure response time.

Note: The Consumer Group and Function categories are valid only for (Oracle 11g and later) (and Consumer Group only for active resource plans).

Total Service Time Chart

For the category you have selected, Total Service Time shows (in milliseconds per second) the rate at which the database is servicing different types of I/O activities.

The chart indicates the overall I/O workload on the database, and a consistently high value in any series may indicate an I/O bottleneck.

You can also compare the data in this chart to the corresponding data in Latency. (High latency for a type of I/O activity may not be significant if the total service time is small.)

If the service time for I/O is a major proportion of the DB time – there may be an I/O performance problem, especially if this is combined with a high latency. If the DB time is a lot higher than the I/O service time, and the latency is low, then I/O is probably not causing a performance problem.

Notes:

  • The data series shown here are the same as those in Latency chart above, with the additional series DB Time — the rate at which time is spent performing user calls on the Oracle database.
  • The Consumer Group and Function categories are valid only for (Oracle 11g and later) (and Consumer Group only for active resource plans).

 

Related Topics

관련 문서

The document was helpful.

평가 결과 선택

I easily found the information I needed.

평가 결과 선택