redo statistics - cheeyoung/sqlplus-public GitHub Wiki
Table E-1 Database Statistics Descriptions
Name | Class | Description | TIMED_STATISTICS |
---|---|---|---|
flashback log write bytes | 2 | Total size in bytes of flashback database data written by RVWR to flashback database logs | |
flashback log writes | 2 | Total number of writes by RVWR to flashback database logs | |
redo blocks checksummed by FG (exclusive) | 2 | Number of exclusive redo blocks that were checksummed by the generating foreground processes. An exclusive redo block is the one whose entire redo content belongs to a single redo entry. | |
redo size for lost write detection | 2 | Total amount of Block Read Records generated in bytes. | |
redo wastage | 2 | Number of bytes wasted because redo blocks needed to be written before they are completely full. Early writing may be needed to commit transactions, to be able to write a database buffer, or to switch logs. | |
redo write broadcast ack count | 2 | Number of times a commit broadcast acknowledgment has not been received by the time when the corresponding log write is completed. This is only for Oracle RAC. | |
redo write broadcast ack time | 2 | Total amount of the latency associated with broadcast on commit beyond the latency of the log write (in microseconds). This is only for Oracle RAC. | Y |
redo write time | 2 | Total elapsed time of the write from the redo log buffer to the current redo log file in 10s of milliseconds | Y |
redo writes | 2 | Total number of writes by LGWR to the redo log files. "redo blocks written" divided by this statistic equals the number of blocks per write |