Hi.
I am developing a P.O.C. where i have an Oracle database, the source, on a VM and another Oracle database, the target, in another VM.
I have all the process implemented and running.
My concerns are regarding the replication times I am getting.
For Extract Lag the delta value is 1,5 Sec.
For Replicat Lag the delta value is 4 Sec.
For Insert operations I created a dummy column with default value as current timestamp to mesure time between the source writing and the target writing. This delta value is 6 Sec.
Are those normal times to insert 100 rows with a commit at the end?
Do you have any performance tunning typ to improve my results?
Below the table definitions, they are equal at source and taget, and the extrac\replicat\mgr files definition.
Table Emp
( ID AS INT PK,
Name as Varchar,
Address as Varchar,
Email as Varchar)
Source mgr:
PORT 7809
Extract:
EXTRACT e1
USERID ggadmin, PASSWORD ggadmin
RMTHOST 192.168.100.1, MGRPORT 7808, TCPBUFSIZE 100000, TCPFLUSHBYTES 300000
RMTTRAIL ./dirdat/dd
CHECKPOINTSECS 1
EOFDELAY 1
TABLE source_db.emp;
Target mgr:
PORT 7808
Replicat:
REPLICAT r1
ASSUMETARGETDEFS
USERID ggadmin, PASSWORD ggadmin
CHECKPOINTSECS 1
EOFDELAY 1
MAP source_db.emp, TARGET target_db.emp
, colmap (id=id, name=name, email=email, address=address);
Best regards,
Andre