Oracle 视图 V$UNDOSTAT 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$UNDOSTAT显示当前的无数据库活动中可用于恢复和回滚操作的回滚段的量化信息。它有助于数据库管理员监控和改进回滚段的性能。
该视图有以下字段：
XACT_SLOTS: 事务 6 个槽位的使用总量（即，当前正在运行的事务数量）。
XACT_EXTENT: 事务段扩展空间的非虚拟字节总量。
UNDO_BLOCKS: 可用来支持回滚操作的回滚块的已使用总量。
UNDO_BLOCKS_USED: 回滚空间中可用用于支持回滚操作的回滚块的已使用总量。
XACT_EXTENTS: 运行时间中可用来支持事务的事务段的使用总量
使用V$UNDOSTAT视图的方法：
1. 执行以下SELECT语句，以检索当前的UNDO数据库活动：
SELECT * FROM V$UNDOSTAT;
2. 使用V$UNDOSTAT视图来监控当前正在运行的事务数量，XACT_SLOTS字段可以用来检查当前正在运行的事务数量：
SELECT XACT_SLOTS FROM V$UNDOSTAT;
3. 使用V$UNDOSTAT视图监控回滚块的使用总量：
SELECT UNDO_BLOCKS FROM V$UNDOSTAT;
4. 使用V$UNDOSTAT视图监控支持执行回滚操作的事务段的使用总量：
SELECT XACT_EXTENTS FROM V$UNDOSTAT;
官方英文解释
V$UNDOSTAT displays a histogram of statistical data to show how well the system is working. The available statistics include undo space consumption, transaction concurrency, and length of queries executed in the instance. You can use this view to estimate the amount of undo space required for the current workload. Oracle uses this view to tune undo usage in the system. The view returns NULL values if the system is in manual undo management mode.
Each row in the view keeps statistics collected in the instance for a 10-minute interval. The rows are in descending order by the BEGIN_TIME column value. Each row belongs to the time interval marked by (BEGIN_TIME, END_TIME). Each column represents the data collected for the particular statistic in that time interval. The first row of the view contains statistics for the (partial) current time period. The view contains a total of 576 rows, spanning a 4 day cycle.
| 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. |
|
|
|
Represents the total number of undo blocks consumed. You can use this column to obtain the consumption rate of undo blocks, and thereby estimate the size of the undo tablespace needed to handle the workload on your system. |
|
|
|
Identifies the total number of transactions executed within the period |
|
|
|
Identifies the length of the longest query (in seconds) executed in the instance during the period. You can use this statistic to estimate the proper setting of the |
|
|
|
SQL identifier of the longest running SQL statement in the period |
|
|
|
Identifies the highest number of transactions executed concurrently within the period |
|
|
|
Number of attempts to obtain undo space by stealing unexpired extents from other transactions |
|
|
|
Number of unexpired blocks removed from certain undo segments so they can be used by other transactions |
|
|
|
Number of unexpired undo blocks reused by transactions |
|
|
|
Number of attempts to steal expired undo blocks from other undo segments |
|
|
|
Number of expired undo blocks stolen from other undo segments |
|
|
|
Number of expired undo blocks reused within the same undo segments |
|
|
|
Identifies the number of times the error |
|
|
|
Identifies the number of times space was requested in the undo tablespace and there was no free space available. That is, all of the space in the undo tablespace was in use by active transactions. The corrective action is to add more space to the undo tablespace. |
|
|
|
Total number of blocks in the active extents of the undo tablespace for the instance at the sampled time in the period |
|
|
|
Total number of blocks in the unexpired extents of the undo tablespace for the instance at the sampled time in the period |
|
|
|
Total number of blocks in the expired extents of the undo tablespace for the instance at the sampled time in the period |
|
|
|
Amount of time (in seconds) for which undo will not be recycled from the time it was committed. At any point in time, the latest value of The value of this column is not meaningful on an Oracle Active Data Guard standby database instance, because the system does not tune this value on such instances. |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
“UNDO_RETENTION”
