Oracle 11gR1
DBA_HIST_UNDOSTAT
displays the history of histograms 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. This view contains snapshots of V$UNDOSTAT
.
Column | Datatype | NULL | Description |
|
|
| Identifies the beginning of the time interval |
|
|
| Identifies the end of the time interval |
|
|
| Database ID for the snapshot |
|
|
| Instance number for the snapshot |
|
|
| Unique snapshot ID |
|
|
| 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 number of 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 |
|
| | System tuned value indicating the period for which undo is being retained |
No comments:
Post a Comment