Sysstat Analysis

Questions or comments ? Send a note to Kyle Hailey

Explication of all stats statistics

Example of a report.txt statistics section statistics

The statistics section of the report.txt is probably the most daunting because of its size and lack of organization. The output is organized alphabetically instead of by subject/domain.

Block Cleanouts
Buffer Pins
Buffer cache
Consistent Read
Cursors
Data Access
Database Writer
Locking
Log Writer
Machine usage
Open Files
Open Sessions
Parallel Query
Parallel Server
Process Communication
Recovery
Scn
Sequences
Sorts
Throughput
User Process Memory

bstat/estat - time period

One important bit of information missing from report.txt, is the number of users logged on. This can be gotten by querying

select value from v$sysstat s, v$statname n where s.statistic#=n.statistic# and n.name='logons current';

In order to better understand the total amount of time waited for events, it is important to know how many users were connected.