7.217 V$FILE_HISTOGRAM
V$FILE_HISTOGRAM
displays a histogram of all synchronous single block reads on a per-file basis (for data files). The histogram has buckets of time intervals from < 1 ms, < 2 ms, < 4 ms, < 8 ms, ... < 221 ms, < 222 ms, and >= 222 ms.
The histogram will not be filled unless the STATISTICS_LEVEL
initialization parameter is set to ALL
.
Column | Datatype | Description |
---|---|---|
|
|
File number |
|
|
Amount of time the bucket represents (in milliseconds). If the duration = |
|
|
Number of waits of the duration belonging to the bucket of the histogram |
|
|
The ID of the container to which the data pertains. Possible values include:
|