1  –  AIJ file writes field

    This field gives the total number of write-I/Os (queued I/O
    requests) issued to the database after-image journal (.aij) file.
    The "data," "control," "file extend," and "switch over" counts
    further subdivide the statistic.

2  –  ____data_field_

    This field gives the number of write-I/Os to the database after-
    image journal file that contained only data records.

3  –  ____control_field_

    This field gives the number of write-I/Os to the database after-
    image journal file that contained OPEN, COMMIT, ROLLBACK, and
    checkpoint records. These writes may also include data records.

4  –  ____file_extend_field_

    This field gives the number of write-I/Os issued to the database
    after-image journal file to initialize new disk blocks when the
    file is extended.

5  –  ____switch_over_field_

    This field gives the number of times AIJ switch-over has occurred
    (the number of times journaling has switched from one journal
    file to another).

6  –  AIJ Write Time field

    This field gives the time (in hundredths of a second) spent
    writing to the .aij file.

7  –  ALS Hiber Count field

    This field displays the number of times the AIJ Log Server
    process spent hibernating while waiting for more work.

8  –  AIJ Hiber Time field

    This field displays the amount of time (in hundredths of a
    second) that processes have spent hibernating while the AIJ log
    server processes their requests.

9  –  AIJ Extend Time field

    This field gives the time (in hundredths of a second) spent
    extending the .aij file. An excessively high number often
    indicates a full disk or disk fragmentation, or may be an
    indication of the need for a larger allocation. Use the JOURNAL
    ALLOCATION IS clause of the SQL ALTER DATABASE statement to
    specify a larger allocation.

10  –  Group Commits field

    This field displays the number of group commit operations
    performed by the ALS process. Dividing the number of transactions
    by the number of groups gives the average group size (the inverse
    of the transaction average display.)

11  –  ARBs formatted field

    This field displays the number of AIJ Request Blocks that were
    formatted by the ALS process.

12  –  ARBs background field

    This field displays the number of AIJ Request Blocks that were
    formatted while asynchronous I/O was being performed to the AIJ
    journal.

13  –  premature_io_saved_field

    This field displays the number of I/Os saved by waiting for more
    work.

14  –  Cache Overflows field

    This field displays the number of times the 64-block .aij cache
    has overflowed.