| | Talking Tuning: Tuning Undo Tablespace (Site not responding. Last check: 2007-11-02) |
 | | Any executing transaction can consume free space in the undo tablespace, and when the transaction completes, its undo space is freed (depending on how it's been sized and a few other factors, as we'll see in a minute). |
 | | As shown in Figure 1, the Undo Management page shows key statistics for the active undo tablespace for the instancethe longest-running query, average kilobytes per minute of undo generated by the system, and the maximum number of kilobytes per minute of undo generated by the system during the selected time period. |
 | | Although the Undo Management page shows you at a glance many of the variables of the existing undo tablespace; its configuration; and how effective that configuration is, given the runtime statistics collected in the AWR, you'll turn to the Undo Advisor when you want to extrapolate how future requirements might affect the undo tablespace size. |
| www.oracle.com /technology/oramag/oracle/05-jul/o45tuning.html (1698 words) |