Historical Reports › FLASHBACK LIST Command › Create a Customized FLASHBACK LIST Report

Create a Customized FLASHBACK LIST Report

You can produce a FLASHBACK LIST report that has:

• The date, time, or day in the first column
• The date and time in the first two columns

To produce either of these reports, specify the DATE, TIME, DAY, or DATETIME operand with the FLASHBACK LIST command.

The width of the output page limits the number of columns that can appear in a report. Use the DATE, TIME, DAY, or DATETIME operand only if you specify the variables to include in your report and limit their number. The number of variables you can specify depends upon the width of the column required for each.

Example: Sample Commands

The following FLASHBACK LIST command is specified with the DATETIME operand. The COUNT command, specified with the SELECTED operand, limits the report to 15 transactions meeting either the FROM or the TO criterion specified.

FLASHBACK LIST DATETIME TRANID TRAN LIFE AND,
                         TRAN I/OTIME    AND,
                         TRAN WAIT       AND,
                         TRAN SUSP       AND,
                         TERM I/OTIME    AND,
                         TRAN CPU
  FROM 12/06/08 21:00:00
  TO   12/06/08 22:00:00
  COUNT 15 SELECTED
END
RUN

A report like the following is generated:

                   TRAN      TRAN     TRAN     TRAN     TRAN     TRAN     TRAN
  DATE     TIME      ID      LIFE      I/O     WAIT     SUSP     TMIO      CPU
-------- -------- -------- -------- -------- -------- -------- -------- --------
12/06/08 21.16.58 CSDA      0.016    0.000    0.000    0.000    0.000    0.011
12/06/08 21.21.52 CIRB      13.30    0.000    1.375    0.000    1.521    1.175
12/06/08 21.22.41 TCP       911.9    0.381    901.3    0.000    0.000    2.110
12/06/08 21.24.20 TCP       912.3    0.000    906.8    0.000    0.000    1.051
12/06/08 21.22.42 KCP       912.3    0.000    0.000    0.000    0.000    1.878
12/06/08 21.23.06 JJJ       937.1    0.000    0.418    934.7    0.000    1.942
12/06/08 21.23.06 CATD      6.529    0.000    0.124    0.000    0.000    0.326
12/06/08 21.23.07 CSNE      0.081    0.000    0.000    0.000    0.000    0.068
12/06/08 21.23.08 CSGM      0.264    0.000    0.000    0.000    0.017    0.010
12/06/08 21.23.15 VGBR      0.332    0.000    0.000    0.000    0.000    0.023
12/06/08 21.23.41 VGBQ      19.33    0.000    0.000    0.000    18.40    0.151
12/06/08 21.28.18 VGBS      306.6    0.000    0.000    0.000    304.6    0.633
12/06/08 21.28.20 CSAC      0.647    0.000    0.000    0.000    0.000    0.015
12/06/08 21.28.23 END       0.486    0.000    0.000    0.000    0.000    0.232
12/06/08 21.28.23 CSNE      0.020    0.000    0.000    0.000    0.000    0.003
-------- -------- -------- -------- -------- -------- -------- -------- --------
12/06/08 21.28.23           251.3    0.024    113.1    58.42    20.29    0.602
-------- -------- -------- -------- -------- -------- -------- -------- --------