TOCPREVNEXTINDEX

Lund Performance Solutions


SOS Oracle Detail Rollback
Segments

The Oracle Detail Rollback Segments Screen

Rollback segments are the segments in which Oracle puts the rollback data when data is modified during a transaction. It provides consistent data for the other readers and in case of a rollback it is used to bring the data to its previous state.
To view statistics related to Oracle rollback segments:
  • Type s from the SOS Enter command: prompt to view the Screen Selection Menu.
  • From the Screen Selection Menu, enter K (upper case) from any SOS display screen. An example of this screen is shown in Figure 38.1.




  • Figure 38.1 SOS Oracle Detail Rollback Segments screen

    Oracle Detail Rollback Segments Display Items

    The Oracle Detail Rollback Segments data items are described in the next table.
    Table 38.1 SOS Oracle Detail Rollback Segments data items
    Data Item
    Description
    Waits
    The number of waits for data from a rollback segment.
    Gets
    The number of readings from a rollback segment.
    Writes
    The number of writes in the rollback segment.
    Hit Ratio
    [(1 - waits / gets) * 100}

    Lund Performance Solutions
    www.lund.com
    Voice: (541) 812-7600
    Fax: (541) 81207611
    info@lund.com
    TOCPREVNEXTINDEX