Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 148 of 211


V$ROLLSTAT

This view contains rollback segment statistics.

Column  Datatype  Description 

USN 

NUMBER 

Rollback segment number 

EXTENTS 

NUMBER 

Number of extents in rollback segment 

RSSIZE 

NUMBER 

Size in bytes of rollback segment. This values differs by the number of bytes in one database block from the value of the BYTES column of the ALL/DBA/USER_SEGMENTS views.

See Also: Oracle9i Database Administrator's Guide

WRITES 

NUMBER 

Number of bytes written to rollback segment 

XACTS 

NUMBER 

Number of active transactions 

GETS 

NUMBER 

Number of header gets 

WAITS 

NUMBER 

Number of header waits 

OPTSIZE 

NUMBER 

Optimal size of rollback segment 

HWMSIZE 

NUMBER 

High water mark of rollback segment size 

SHRINKS 

NUMBER 

Number of times the size of a rollback segment decreases 

WRAPS 

NUMBER 

Number of times rollback segment is wrapped 

EXTENDS 

NUMBER 

Number of times rollback segment size is extended 

AVESHRINK 

NUMBER 

Average shrink size 

AVEACTIVE 

NUMBER 

Current size of active extents, averaged over time. 

STATUS 

VARCHAR2(15) 

Rollback segment status 

CUREXT 

NUMBER 

Current extent 

CURBLK 

NUMBER 

Current block 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback