Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E41527-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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:

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 VARCHAR2(128) NOT NULL Owner of the base table registered for synchronous refresh
TABLE_NAME VARCHAR2(128) NOT NULL Name of the table
STAGING_LOG_NAME VARCHAR2(128) NOT NULL Name of the staging log for tables. NULL for materialized views
NUM_INSERTS NUMBER NOT NULL The number of inserts in the staging log
NUM_DELETES NUMBER NOT NULL The number of deletes in the staging log
NUM_UPDATES NUMBER NOT NULL The number of updates in the staging log
PSL_MODE VARCHAR2(33)   The mode specified by the user in running DBMS_SYNC_REFRESH.PREPARE_STAGING_LOG. Possible values:
  • DELETE_TRUSTED

  • DELETE_TRUSTED and UPDATE_TRUSTED

  • ENFORCED

  • INSERT_TRUSTED

  • INSERT_TRUSTED and DELETE_TRUSTED

  • TRUSTED

  • UPDATE_TRUSTED

  • UPDATE_TRUSTED and INSERT_TRUSTED


See Also: