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}