select apply#, server_id, save_time, source_table_owner, source_table_name,
destination_table_owner, destination_table_name, last_update,
total_inserts, total_updates, total_deletes, insert_collisions,
update_collisions, delete_collisions, reperror_records,
reperror_ignores, wait_dependencies, cdr_insert_row_exists,
cdr_update_row_exists, cdr_update_row_missing, cdr_delete_row_exists,
cdr_delete_row_missing, cdr_successful_resolutions,
cdr_failed_resolutions, lob_operations, spare1, spare2,
spare3, spare4, spare5, spare6,
spare7, spare8, spare9, spare10, spare11, spare12, spare13, spare14,
spare15, spare16, spare17, spare18, spare19, spare20
from sys.apply$_table_stats
SELECT APPLY#
, SERVER_ID
, SAVE_TIME
, SOURCE_TABLE_OWNER
, SOURCE_TABLE_NAME
,
DESTINATION_TABLE_OWNER
, DESTINATION_TABLE_NAME
, LAST_UPDATE
,
TOTAL_INSERTS
, TOTAL_UPDATES
, TOTAL_DELETES
, INSERT_COLLISIONS
,
UPDATE_COLLISIONS
, DELETE_COLLISIONS
, REPERROR_RECORDS
,
REPERROR_IGNORES
, WAIT_DEPENDENCIES
, CDR_INSERT_ROW_EXISTS
,
CDR_UPDATE_ROW_EXISTS
, CDR_UPDATE_ROW_MISSING
, CDR_DELETE_ROW_EXISTS
,
CDR_DELETE_ROW_MISSING
, CDR_SUCCESSFUL_RESOLUTIONS
,
CDR_FAILED_RESOLUTIONS
, LOB_OPERATIONS
, SPARE1
, SPARE2
,
SPARE3
, SPARE4
, SPARE5
, SPARE6
,
SPARE7
, SPARE8
, SPARE9
, SPARE10
, SPARE11
, SPARE12
, SPARE13
, SPARE14
,
SPARE15
, SPARE16
, SPARE17
, SPARE18
, SPARE19
, SPARE20
FROM SYS.APPLY$_TABLE_STATS
|
|
|