oracle_goldengate
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oracle_goldengate [2018/11/16 07:13] ss_wiki_admin [Tuning STREAMS pool] |
oracle_goldengate [2021/04/23 07:57] (current) ss_wiki_admin [Process Memory Usage] |
||
|---|---|---|---|
| Line 36: | Line 36: | ||
| /* Replicat side */ | /* Replicat side */ | ||
| SELECT r.apply_name, | SELECT r.apply_name, | ||
| + | </ | ||
| + | |||
| + | ==== Heartbeat Table ==== | ||
| + | Show heartbeat for all extracts and replicats | ||
| + | <code sql> | ||
| + | select * from ggadmin.gg_heartbeat; | ||
| + | </ | ||
| + | Show lag history | ||
| + | <code sql> | ||
| + | set pagesize 200 linesize 200 | ||
| + | col heartbeat_received_ts format a30 | ||
| + | col incoming_path format a24 | ||
| + | col incoming_lag format 999,999.999 | ||
| + | ALTER SESSION SET NLS_DATE_FORMAT=' | ||
| + | SELECT heartbeat_received_ts, | ||
| </ | </ | ||
| Line 67: | Line 82: | ||
| If there are many wait dependencies when using integrated Replicat, try reducing the value of BATCHTRANSOPS. | If there are many wait dependencies when using integrated Replicat, try reducing the value of BATCHTRANSOPS. | ||
| <code sql> | <code sql> | ||
| - | select APPLY_NAME, STATE, ACTIVE_SERVER_COUNT, | + | select APPLY_NAME, STATE, ACTIVE_SERVER_COUNT, |
| </ | </ | ||
| Line 174: | Line 189: | ||
| # Individual extract Process Usage # | # Individual extract Process Usage # | ||
| ##################################### | ##################################### | ||
| - | 41.7109 MB DP_CLI | + | 41.7109 MB DP_C |
| - | 31.9805 MB DP_FMS | + | 31.9805 MB DP_F |
| - | 29.9297 MB DP_MR | + | 29.9297 MB DP_M |
| - | 37.3672 MB DP_MR_O | + | 37.3672 MB DP_M_O |
| - | 37.8438 MB DP_SDE | + | 37.8438 MB DP_S |
| - | 29.1562 MB DP_SERV | + | 29.1562 MB DP_SV |
| - | 1516.69 MB EXT_CLI | + | 1516.69 MB EXT_C |
| - | 74.8516 MB EXT_FMS | + | 74.8516 MB EXT_F |
| - | 556.352 MB EXT_MR | + | 556.352 MB EXT_M |
| - | 246.926 MB EXT_MR_O | + | 246.926 MB EXT_M_O |
| - | 68.7773 MB EXT_SDE | + | 68.7773 MB EXT_S |
| - | 91.5234 MB EXT_SERV | + | 91.5234 MB EXT_SV |
| ##################################### | ##################################### | ||
| Line 196: | Line 211: | ||
| </ | </ | ||
| + | ==== Apply Server Details ==== | ||
| + | <code sql> | ||
| + | select APPLY_NAME, APPLY#, SERVER_ID, STATE, TOTAL_MESSAGES_APPLIED from V$GG_APPLY_SERVER ORDER BY APPLY_NAME, SERVER_ID; | ||
| + | </ | ||
| + | ==== Apply Coordinator Detail ==== | ||
| + | <code sql> | ||
| + | SELECT APPLY_NAME, STATE, TOTAL_APPLIED, | ||
| + | </ | ||
| + | ==== Queue Status ==== | ||
| + | <code sql> | ||
| + | SELECT DST_QUEUE_SCHEMA, | ||
| + | </ | ||
| + | |||
| + | ==== Apply Latency ==== | ||
| + | <code sql> | ||
| + | SELECT r.apply_name, | ||
| + | </ | ||
| + | |||
| + | ==== Trace Monitoring ==== | ||
| + | under OGG installation home directory, create an xml file named gglog-< | ||
| + | gglog-< | ||
| + | <code xml> | ||
| + | <?xml version=" | ||
| + | < | ||
| + | < | ||
| + | <param name=" | ||
| + | <param name=" | ||
| + | <layout class=" | ||
| + | </ | ||
| + | <logger name=" | ||
| + | <level value=" | ||
| + | </ | ||
| + | </ | ||
| + | </ | ||
oracle_goldengate.1542352408.txt.gz · Last modified: 2019/09/16 16:09 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
