`V$SYS_TIME_MODEL`

displays the system-wide accumulated times for various operations. The time reported is the total elapsed or CPU time (in microseconds). Any timed operation will buffer at most 5 seconds of time data. Specifically, this means that if a timed operation (such as SQL execution) takes a long period of time to perform, the data published to this view is at most missing 5 seconds of the time accumulated for the operation.

The time values are 8-byte integers and can therefore hold approximately 580,000 years worth of time before wrapping. Background process time is not included in a statistic value unless the statistic is specifically for background processes.

Column | Datatype | Description |
---|---|---|

`STAT_ID` |
`NUMBER` |
Statistic identifier for the time statistic |

`STAT_NAME` |
`VARCHAR2(64)` |
Name of the statistic (see Table 7-4) |

`VALUE` |
`NUMBER` |
Amount of time (in microseconds) that the system has spent in this operation |