|
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
22、查看目标端extrace信息
GGSCI (target) 6> view report rinikk
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 15:35:17
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-09-04 14:06:13
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
Node: target
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 3888
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
-- This is replicate parameter file
REPLICAT RINIKK
ASSUMETARGETDEFS
USERID system , PASSWORD ******
DISCARDFILE ./dirrpm/RINIKK.dsc , PURGE
MAP ggs.* , TARGET ggs.*;
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 512M
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 1G
CACHESIZEMAX (strict force to disk): 881M
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
***********************************************************************
** Run Time Messages **
***********************************************************************
Wildcard MAP resolved (entry GGS.*):
MAP GGS.TCUSTMER, TARGET ggs.TCUSTMER;
Using following columns in default map by name:
CUST_CODE, NAME, CITY, STATE
Using the following key columns for target table GGS.TCUSTMER: CUST_CODE.
Wildcard MAP resolved (entry GGS.*):
MAP GGS.TCUSTORD, TARGET ggs.TCUSTORD;
Using following columns in default map by name:
CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID, PRODUCT_PRICE,
PRODUCT_AMOUNT, TRANSACTION_ID
Using the following key columns for target table GGS.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2014-09-04 14:06:26 (activity since 2014-09-04 14:06:19)
From Table GGS.TCUSTMER to GGS.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table GGS.TCUSTORD to GGS.TCUSTORD:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
CACHE OBJECT MANAGER statistics
CACHE MANAGER VM USAG |