12 tables in 36 databases target-side inbound process splitbecause the target side of the Ogg inbound process synchronization of more tables, large amounts of data, resulting in the storage process delays. In the case of sufficient host CPU and memory, it is possible to split a process with a delay, divide multiple tables from one process to another process, or synchronize a table with a large amount of data in several processes.
process description for split process:1) Find the process where the split table is located 2) the process that the split table is located in 3) gets the seqno and RBA number 4 of the process in which the splitter table is located (mapexclude) 5) Add split process 6) specify the split process Read seqno and RBA of queue files 7) Edit split new process 8) Start Process Note: Please read the above process first, then do the following!
1. Determine the table that needs to split the process (this example splits 12 tables) hx_sb.sb_dkdj_skbg This table splits 3 processes hx_sb.sb_sbb This table splits 6 processes HX_ sb.sb_zzs_fb_zzsjmssbmxb_msxm This table splits 3 processes hx_sb.sb_zzs_xgm nbsp This table splits 6 processes hx_sb.sb_zzs_xgm_fb_flzl The table splits 3 Process HX_SB. sb_zzs_ybnsr This table splits 3 processes HX_SB. sb_zzs_ybnsr_fb_jxsejgmxb This table splits 6 processes HX_SB. sb_zzs_ybnsr_fb_ygzsffxcsm This table splits 3 processes HX_SB. sb_zzs_ybnsr_fb_ynseayskm This table splits 3 processes HX_SB. sb_zzs_ybnsr_fb1_bqxsqkmx This table splits 6 processes HX_SB. sb_zzs_ybnsr_fb2_bqjxsemx This table splits 6 processes HX_SB. sb_zzs_ybnsr_fb5_bdcfqdkb  This table splits 3 processes
2. The process of the above 12 tables is the one that needs to be split. Find the process that contains the 12 tables you want to split:Example: View param rzg_ff2b--HX_SB. SB_SBB view param rzg_ff2h--hx_sb. SB_ZZS_YBNSR_FB1_BQXSQKMX view param rzg_ff2i--hx_sb. Sb_zzs_ybnsr_fb2_bqjxsemx view param rzg_ff2j--hx_sb. SB_ZZS_YBNSR HX_SB. SB_ZZS_XGM view param rzg_ff2n--hx_sb. Sb_zzs_xgm_fb_flzl view param RZG_FF2A-Contains the remaining 6 sheets
3, stop the need to split (row table) of the inbound processStop rzg_ff2b Stop rzg_ff2h stop rzg_ff2i stop rzg_ff2j stop rzg_ff2n stop RZG_FF2A
4, take the current seqno and RBA number, such as XX units as follows Example: Ggsci (nmsthxffdb01) 3> info rzg_ff2b replicat RZG_FF2B Last Started 2017-01-14 19:07 status running Checkpoint lag 01:23:38 (U pdated 02:20:38 ago) Log Read checkpoint File ./dirdat/zb002751 &NBSP ; 2017-01-14 17:22:34.052064 RBA 347329296 Info RZG _ff2b -- zb002751 RBA 347329296 Info rzg_ff2h &NBSP ;-- zb002751 RBA 347335602 Info rzg_ff2i -- zb002751 RBA 34733560 2 Info rzg_ff2j -- zb002751 RBA 347335602 Info rzg_f f2n -- zb002751 RBA 347378402 Info rzg_ff2a - - zb002751 RBA 347521117
5. Schedule the original process (edit process, add the statement to exclude the table, if there are only 1 tables in the process, do not need to exclude)Example (add the following mapexclude list statement, added below the last parameter, and then save exit): Eidt param rzg_ff2a mapexclude hx_sb. SB_DKDJ_SKBG, Mapexclude HX_SB. SB_ZZS_YBNSR_FB_JXSEJGMXB, Mapexclude HX_SB. SB_ZZS_YBNSR_FB_YGZSFFXCSM, Mapexclude HX_SB. SB_ZZS_YBNSR_FB_YNSEAYSKM, Mapexclude HX_SB. SB_ZZS_FB_ZZSJMSSBMXB_MSXM, Mapexclude HX_SB. SB_ZZS_YBNSR_FB5_BDCFQDKB;
6, add the split process, according to the amount of data found above to split a process for multiple processes (3 or 6 processes), the new process naming format: rsb_p**, where "*" represents a number, and increments from 01Example:
split three processes as follows:Add Replicat rsb_p01, Exttrail./dirdat/zb add Replicat rsb_p02, Exttrail./dirdat/zb add Replicat rsb_p03, exttrail./d Irdat/zb
split six processes as follows:Add Replicat rsb_p04, Exttrail./dirdat/zb add Replicat rsb_p05, Exttrail./dirdat/zb add Replicat rsb_p06, exttrail./d IRDAT/ZB add Replicat rsb_p07, Exttrail./dirdat/zb add Replicat rsb_p08, Exttrail./dirdat/zb add Replicat RSB_P09, E Xttrail./dirdat/zb
7. Specify seqno and RBA of new process, above "info process name" (Note process name correspondence)
split three processes as follows:Alter Replicat RSB_P01, Extseqno 002751, Extrba 347521117 alter Replicat RSB_P02, Extseqno 002751, Extrba 347521117 alte R Replicat rsb_p03, Extseqno 002751, Extrba 347521117
split six processes as follows:Alter Replicat RSB_P04, Extseqno 002751, Extrba 347329296 alter Replicat RSB_P05, Extseqno 002751, Extrba 347329296 alte R Replicat rsb_p06, Extseqno 002751, Extrba 347329296 alter Replicat rsb_p07, Extseqno 002751, Extrba 347329296 alter RE Plicat rsb_p08, Extseqno 002751, Extrba 347329296 alter Replicat rsb_p09, Extseqno 002751, Extrba 347329296
8. Edit the new process of splittingNote: 1) replicat rsb_p01 2) discardfile./dirrpt/rsb_p01.dsc,append,megabytes 100 3) split table name Example: edit param rsb_p01 replicat rsb_p01 SETENV (oracle_sid= "Nmsthxff" ) SETENV (Nls_lang=american_america. Al32utf8) Userid Ggs,password AACAAAAAAAAAAAIAUCOJGDDFPFHEGCPD, BLOWFISH, Encryptkey default 01:59 Reportrollover at 02:00 Cachemgr, CACHESIZE 256mb Reperror DEFAULT, abend discardfile/dirrpt/rsb_p01.dsc,append,megabytes 100 Discardrollover at 06:00 & nbsp gettruncates numfiles 3000 eofdelaycsecs 30 assumetargetdefs allownoopupdates dynamicresolution getupdatebefores nocompressdeletes MAP HX_SB. SB_DKDJ_SKBG, TARGET HX_SB. SB_DKDJ_SKBG, Colmap (usedefaults, & &NBSp SJTB_SJ = @date ("Yyyy-mm-dd hh:mi:ss.ffffff", "JTS", @GETENV ("Juliantimestamp")), FILTER (@RANGE (1,4));--1 Here is the first process of a table split, and 4 is the total split into 4 processes
9, start the process (note: Must start the new split process, and so the new process does not delay, and then start the original process)Example:--Split new process start Rsb_p01 start RSB_P02 start rsb_p03--original process start RZG_FF2A-Split new process start rsb_p04 start RSB_P05 sta RT rsb_p06 Start rsb_p07 start rsb_p08 start rsb_p09--original process start RZG_FF2B--OK!!
Ogg Process Split