1.161 STATOPTIONS
Valid For
Extract and Replicat
Description
Use the STATOPTIONS
parameter to specify the information that is to be included in statistical displays generated by the STATS EXTRACT
or STATS REPLICAT
command. These options also can be enabled as needed as arguments to those commands.
Default
See individual options.
Syntax
STATOPTIONS [, REPORTDETAIL | NOREPORTDETAIL] [, REPORTFETCH | NOREPORTFETCH] [, RESETREPORTSTATS | NORESETREPORTSTATS] [, THREADS (threadID
[,threadID
][, ...][,thread_range
[,thread_range
][, ...])]
-
REPORTDETAIL | NOREPORTDETAIL
-
Valid for Replicat. Controls the reporting of statistics for operations that were not applied to the target because they were discarded as the result of collision handling.
-
REPORTDETAIL
-
Returns statistics for the discarded operations. These operations are reported in the regular
STATS REPLICAT
statistics (inserts, updates, and deletes performed) and as discard statistics ifSTATS REPLICAT
is issued with theDETAIL
option. For example, if 10 records wereINSERT
operations and they were all ignored due to duplicate keys, the report would indicate that there were 10 inserts and also 10 discards due to collisions.REPORTDETAIL
is the default. -
NOREPORTDETAIL
-
Turns off the reporting of statistics for discarded operations.
-
-
REPORTFETCH | NOREPORTFETCH
-
Valid for Extract. Controls the reporting of statistics for the amount of row fetching performed by Extract, such as the fetches that are triggered by a
FETCHCOLS
clause or fetches that must be performed when not enough information is in the transaction record.-
REPORTFETCH
-
Reports statistics for row fetching. The output is as follows:
-
row fetch attempts
: The number of times Extract attempted to fetch a column value from the database when it could not obtain the value from the transaction log. -
fetch failed
: The number ofrow fetch attempts
that failed. -
row fetch by key: (Valid for Oracle) The number of row fetch attempts that were made by using the primary key.
-
-
NOREPORTFETCH
-
Turns off the reporting of fetch statistics.
NOREPORTFETCH
is the default.
-
-
RESETREPORTSTATS | NORESETREPORTSTATS
-
Valid for Extract and Replicat. Controls whether or not statistics generated by the
REPORT
parameter are reset when a new report is created.RESETREPORTSTATS
resets the statistics from one report to the other.NORESETREPORTSTATS
continues the statistics from one report to another and is the default, see REPORT. Report rollover is controlled by theREPORTROLLOVER
parameter, see REPORTROLLOVER.-
THREADS (
threadID
[,
threadID
][, ...][,
thread_range
[,
thread_range
][, ...]
)
-
Enables the selected
STATOPTIONS
options for the specified threads of a coordinated Replicat.-
threadID
[,
threadID
][, ...]
-
Specifies a thread ID or a comma-delimited list of threads in the format of
threadID, threadID, threadID
. -
[,
thread_range
[,
thread_range
][, ...]
-
Specifies a range of threads in the form of
threadIDlow-threadIDhigh
or a comma-delimited list of ranges in the format ofthreadIDlow-threadIDhigh
,threadIDlow-threadIDhigh
.
A combination of these formats is permitted, such as
threadID
,threadID
,threadIDlow-threadIDhigh
. -
-
Parent topic: Oracle GoldenGate Parameters