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
-
Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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
- 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 Page | Event 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
- (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
- 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).