ITPub博客

首页 > 数据库 > Oracle > OGG Director status reporting [ID 1345697.1]

OGG Director status reporting [ID 1345697.1]

原创 Oracle 作者:msdnchina 时间:2011-10-21 17:47:39 0 删除 编辑

Applies to:

Management Pack for Oracle GoldenGate - Version: 2.0.0.0 and later [Release: 2.0 and later ]
Information in this document applies to any platform.

Goal

How do we enable reporting for GoldenGate Director, so that the reports can be published to the teams?

Solution

OGG Director has no functionality to generate reports. Director does keep the current status of each monitored OGG process in the repository. You can query the Director repository to get the current status of processes monitored by Director:

SELECT commonname, processtype, laststatus, statustimestamp, lastcheckpointlag
FROM .aconprocsb
WHERE processname <> 'MGR';

Then add the query results to an email distribution list to publish your statuses.[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/161195/viewspace-1055854/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1542056