File IO statistics


Job details

Name: File IO statistics
Platform: Oracle
Category: Performance
Description: Collects I/O statistics for data files.
Long description: Returns I/O statistics for data files based on dynamic performance view gv$datafile
Version: 2.9
Default schedule: 0,10,20,30,40,50 * * *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & ten_and_above=‘1′]

Parameters

Name Default value Description
keep data for 14 Number of days to provide statistics for.
keep aggregated data for 60 Number of days to provide aggregated statistics for.
ignore tablespaces A list of tablespaces to be ignored (separated by comma).

Job Summary

Specific Information

This monitoring job, by using views such as gv$datafile and related tables, keeps an eye on various I/O operations metrics including:

The job’s output includes detailed latency statistics over time, helping identify trends and periods of peak load, which can be critical for performance tuning and capacity planning.

Implementation Details

Dependencies and Cleanup

This job has dependencies on various helper tables and history tables. On failure, these objects are subject to cleanup operations to prevent corrupted data from interfering with future data collection and reporting. The dependencies are as follows:

Scheduled Operations

Report Features and Data Presentation

The reporting templates built into the job provide a range of visual and tabular data representations, including:

Adopting such a focused approach allows database teams to quickly drill down into areas of interest or concern, making this job an integral part of database health monitoring and optimization within operational environments powered by Oracle databases.