Oracle Internals

Oracle 10.2 Segment Statistics

In both Oracle 10.1 and Oracle 10.2 there are 15 segment statistics.

There are no differences between the segment statistics in the aforementioned versions.

The following table shows the 15 segment statistics in Oracle 10.2:

Name

buffer busy waits

db block changes

gc buffer busy

gc cr blocks received

gc current blocks received

ITL waits

logical reads

physical reads

physical reads direct

physical writes

physical writes direct

row lock waits

segment scans

space allocated

space used