5.389 DBA_SR_STLOG_STATS
DBA_SR_STLOG_STATS
provides information on the statistics in the staging logs for the tables processed by DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG
.
These three statistics columns in the staging log are filled in PREPARE_STAGING_LOG
:
-
The number of inserts (
NUM_INSERTS
) -
The number of deletes (
NUM_DELETES
) -
The number of updates (
NUM_UPDATES
)
After the data in the staging logs of a synchronous refresh group have been processed by PREPARE_REFRESH
and EXECUTE_REFRESH
, the statistics columns for the tables in the group are cleared and appear as NULL
.
Related View
USER_SR_STLOG_STATS
provides information on the statistics in the staging logs for the tables belonging to the current user processed by DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the base table registered for synchronous refresh |
|
|
|
Name of the table |
|
|
|
Name of the staging log for tables. NULL for materialized views |
|
|
|
The number of inserts in the staging log |
|
|
|
The number of deletes in the staging log |
|
|
|
The number of updates in the staging log |
|
|
|
The mode specified by the user in running
|
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_SYNC_REFRESH
package