Hi All,
I'm trying to implement GG, but experience too much lag...
My settings:
2 Linux virtual servers on same host.
Oracle db 12 on both servers
Both servers can reach each other on DNS name.
I'm trying to replicate data from the database on server 2 towards the database on server 1. If I do an update of 1 row in the source, followed by commit, it takes about 4-6 seconds before the data is visible in the target. It should not be the amount of data, I update 1 varchar field in a table of 6 records :-)
Data is duplicated, it only takes far too long to be done. Probably missed something trivial, please have a look on my configs...
My param files (mgr file is identical on both servers, they act on active-active configuration):
GGSCI (server-02) 1> view param mgr
PORT 7809
DynamicPortList 20000-20099
PurgeOldExtracts ./dirdat/*, UseCheckPoints, MinKeepHours 2
Autostart ER *
AUTORESTART Extract *, WaitMinutes 1, Retries 3, ResetMinutes 60
LAGINFOMINUTES 0
LAGREPORTMINUTES 1
GGSCI (server-02) 2> view param e_tkm
Extract e_tkm
SETENV (ORACLE_SID='xxxxx2')
UserIdAlias ogg_user
TranlogOptions IntegratedParams (max_sga_size 256)
TranlogOptions ExcludeUser ogguser
Exttrail ./dirdat/in
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
TABLE xxxxx.TKM_VAULT_OPERATION;
GGSCI (server 02) 3> view param p_tkm
extract p_tkm
SETENV (ORACLE_SID='xxxxxx2')
UserIdAlias ogg_user
rmthost server-01, mgrport 7809
rmttrail ./dirdat/pn
TABLE xxxxx.TKM_VAULT_OPERATION;
GGSCI (server 01) 1> view param r_tkm
Replicat r_tkm
SETENV(ORACLE_SID='xxxxxx1')
DBOPTIONS INTEGRATEDPARAMS(parallelism 6)
AssumeTargetDefs
DiscardFile ./dirrpt/rpdw.dsc, Purge
UserIdAlias ogg_user
Map xxxxxx.TKM_VAULT_OPERATION, target xxxxxx.TKM_VAULT_OPERATION;
After executing 1 update I see the following lag info:
GGSCI (server 02 as ogguser@xxxxxx2) 10> lag e_tkm
Sending GETLAG request to EXTRACT E_TKM ...
Last record lag 1 seconds.
GGSCI (server02 as ogguser@xxxxxx2) 11> lag p_tkm
Sending GETLAG request to EXTRACT P_TKM ...
Last record lag 2 seconds.
At EOF, no more records to process.
GGSCI (server 01 as ogguser@xxxxxx1) 5> lag r_tkm
Sending GETLAG request to REPLICAT R_TKM ...
Last record lag 4 seconds.
Low watermark lag: 78.
High watermark lag: 15.
Low watermark position: 740977.
High watermark position: 741015.
At EOF, no more records to process.
What could be the cause of this? Any help or suggestion is highly appreciated!
Thanks,
Jeroen