Statistics=(stat-opts)
Specifies that statistics are to be displayed at regular
intervals or each time a transaction commits, or both, so that
you can evaluate the progress of the load operation.
The stat-opts are the options you can specify with this
qualifier, namely: Interval=n, On_Commit, or both. If the
Statistics qualifier is specified, you must also specify at least
one option.
When the Statistics=(Interval=n) qualifier is specified, Oracle
RMU prints statistics every n seconds. The minimum value for n is
1.
When the Statistics=(On_Commit) qualifier is specified, Oracle
RMU prints statistics each time a transaction is committed.
If you specify both options, Statistics=(Interval=n, On_Commit),
statistics are displayed every n seconds and each time a
transaction commits.
The displayed statistics include:
o Elapsed time
o CPU time
o Buffered I/O
o Direct I/O
o Page faults
o Number of records loaded when the last transaction was
committed
o Number of records loaded so far in the current transaction
o If the Record_Definition=Exception_File option is also
specified, the following statistics are displayed also:
- Number of records rejected when the last transaction was
committed
- Number of records rejected so far in the current
transaction
o If the Parallel qualifier is specified also, the following
statistics are displayed also:
- Number of extra commits performed by executors
Extra commits are caused when the Oracle RMU directs your
process or the executors to commit a transaction earlier
than usual to avoid a hung load operation. For example, if
one executor is holding, but no longer needs a lock that
another executor requires, Oracle RMU directs the first
executor to commit its current transaction. By directing an
executor or executors to commit a transaction earlier than
usual, the locks under contention are released and the load
operation can proceed.
- The total number of executors
- The number of executors that are initializing, idle,
terminated, sorting, storing, committing, or executing
At any time during the load operation, you can press Ctrl/T to
display the current statistics.