Oracle 视图 V$TEMPUNDOSTAT 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$TEMPUNDOSTAT显示当前正在撤消临时表空间中的活动，以及这些活动中正在执行的UNDO会话的细节信息。
用途:
V$TEMPUNDOSTAT表可以用来检测UNDO过程是否正确运行，以及未提交事务是否发生。它可以帮助管理员识别可能对数据库性能或完整性有影响的潜在操作。
使用方法:
要查看正在撤消的临时表空间，使用以下SQL语句.
SELECT *
FROM V$TEMPUNDOSTAT
官方英文解释
V$TEMPUNDOSTAT shows various statistics related to the temporary undo log for this database instance. It displays a histogram of statistical data to show how the system is working. Each row in the view keeps statistics collected in the instance for a 10-minute interval. The rows are in the descending order of the BEGIN_TIME column value. This view contains a total of 576 rows, spanning a 4-day cycle. This view is similar to the V$UNDOSTAT view.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Identifies the beginning of the time interval |
|
|
|
Identifies the end of the time interval |
|
|
|
Represents the last active undo tablespace in the duration of time. The tablespace ID of the active undo tablespace is returned in this column. If more than one undo tablespace was active in that period, the active undo tablespace that was active at the end of the period is reported. |
|
|
|
Total number of transaction that have bound to the temp undo segment contained in above tablespace within the interval period |
|
|
|
Highest number of transactions executed concurrently which modified temporary objects within the interval period |
|
|
|
Reserved for future use |
|
|
|
Reserved for future use |
|
|
|
Total number of temporary undo blocks consumed |
|
|
|
Total number of extents consumed |
|
|
|
Temp undo segments created in this period |
|
|
|
Identifies the number of times the error |
|
|
|
Total number of times the error ‘no space left for temporary undo’ was raised |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“V$UNDOSTAT”
