7.135 V$CON_SYS_TIME_MODEL
V$CON_SYS_TIME_MODEL
displays the systemwide accumulated times for various operations for the container from which it is queried.
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 |
---|---|---|
|
|
Statistic identifier for the time statistic |
|
|
Name of the statistic (see Table 9-1) |
|
|
Amount of time (in microseconds) that the system has spent in this operation |
|
|
When queried from a non-CDB, the accumulated times for operations in that instance are returned, and the When queried from the root of a CDB, accumulated times for operations in every container are returned, and the When queried from a PDB, accumulated times for operations in that PDB are returned, and the |