V$OB_SYS_TIME_MODEL

Purpose

The V$OB_SYS_TIME_MODEL view displays the time model statistics of the current node at the tenant level.

Columns

| VALUE | NUMBER | No | Stat value |

The following table describes the statistics events and their IDs in the STAT_NAME column of the view. | Statistics event | Description | Stat ID | Stat type | | ------------|------|------------|----------------| | DB time | Total time spent on database activities, which is the sum of CPU time and non-idle wait time. | 200001 | 3072 | | DB CPU | Total CPU time spent on database activities. | 200002 | 3072 | | background elapsed time | Total time spent by background processes. | 200005 | 3072 | | background cpu time | Total CPU time consumed by background processes. | 200006 | 3072 | | non idle wait time | Total time spent in non-idle wait states, which are wait states other than idle wait states. | 200010 | 3072 | | idle wait time | Total time spent in idle wait states. | 200011 | 3072 | | background database time | Total time spent by background processes on database operations. | 200012 | 3072 | | background database non-idle wait time | Total time spent by background processes on database operations in non-idle wait states. | 200013 | 3072 | | background database idle wait time | Total time spent by background processes on database operations in idle wait states. | 200014 | 3072 | | concurrency wait total time | Total wait time due to concurrency issues, such as wait time due to resource locking. | 220001 | 3072 | | user io wait total time | Total time spent waiting for I/O operations (such as data read and write to disk) to complete by user processes. | 220002 | 3072 |

| application wait total time | Total wait time generated by user application code (such as lock wait time caused by row-level locking or explicit locking commands).| 2200013 | 3072 |

Sample query

obclient [SYS]> SELECT * FROM SYS.V$OB_SYS_TIME_MODEL;

The query result is as follows:

+-----------+----------------+----------+---------+-------------------------+------------+
| TENANT_ID | SVR_IP         | SVR_PORT | STAT_ID | STAT_NAME               | VALUE      |
+-----------+----------------+----------+---------+-------------------------+------------+
|      1004 | 172.xx.xxx.xxx |     2882 |  200001 | DB time                 |  383173563 |
|      1004 | 172.xx.xxx.xxx |     2882 |  200002 | DB CPU                  |  379092487 |
|      1004 | 172.xx.xxx.xxx |     2882 |  200005 | background elapsed time | 3523356618 |
|      1004 | 172.xx.xxx.xxx |     2882 |  200006 | background cpu time     | 3185615826 |
|      1004 | 172.xx.xxx.xxx |     2882 |  200010 | non idle wait time      |    4081076 |
|      1004 | 172.xx.xxx.xxx |     2882 |  200011 | idle wait time          |      20114 |
+-----------+----------------+----------+---------+-------------------------+------------+
6 rows in set

References

• GV$OB_SYS_TIME_MODEL

• GV$OB_SESS_TIME_MODEL

• V$OB_SESS_TIME_MODEL

• DBA_WR_SYS_TIME_MODEL