Oracle 视图 V$CON_SYS_TIME_MODEL 官方解释，作用，如何使用详细说明
本站中文解释
此视图V$CON_SYS_TIME_MODEL中包含每个会话（活动连接）一个连接关联的时间模型，可以帮助DBA确定影响某会话执行事务的时间模型名称，以及最大会话和等待时间的参数。
使用方法： DBA可以使用此视图来获取每个会话的时间模型信息。例如，使用下面的SQL语句可以查看某个会话（本例中的CON_ID为3）当前使用的时间模型：
SELECT * FROM V$CON_SYS_TIME_MODEL WHERE CON_ID=3;
此查询语句将返回指定会话使用的时间模型名称、最大会话和最大等待时间值。
官方英文解释
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 10-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 |
