demonson的专栏

1.检查目标库SQL server上ogg进程是否正常info allinfo rerstats rer,total若是ogg的mgr或rer进程stop/abended状态start mgrstart rer2.检查目标库Oracle上ogg进程是否正常info allinfo exinfo pupstats pup,total若是ogg的mgr/ex/pup进程stop/abended状态start mgrstart exstart..

一、开启审计，记录sql--Oracle审计https://max.book118.com/html/2016/1214/72170219.shtm--开启审计alter system set audit_sys_operations=TRUE scope=spfile;alter system set audit_trail=db,extended scope=spfile;--重启实例shutdown immediatestartup--查看审计状态SYS@orcl>sh

1.通过Oracle快照定位慢日志Oracle快照每小时产生一个，每个快照包含了一小时内所需记录sql的执行情况快照视图：DBAHISTSQLSTAT详解https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/DBA_HIST_SQLSTAT.html#GUID-F5A246E0-C04A-406C-9E10-AC26E7742F06编辑2.创建视图，用于查询最新一小时的慢SQLcreate or.