Hello,experts
Now,there have plenty of wait events of DBLINK from 4:00 AM to 6:00 AM during that time period every day on Oracle DB 11.2.0.4.0 Data Guard primary For Linux x64.
I have captured an AWR report for comparing during that time period.
See my snapshot as follows,




Next,it's AWRSQLRPT report about two sql(from snapshot previous using red rectangular box to mark).
- SQL_ID is 5hv12nch90c64



- SQL_ID is 3dvhmxnrh4pku



Finally,I have used VIEW v$active_session_history(ASH) to check numbers of wait events about DBLINK during that time period.
SYS@orcl29> set linesize 400
SYS@orcl29> set pagesize 500
SYS@orcl29> col sql_id for a15
SYS@orcl29> col event for a30
SYS@orcl29> col count(*) for 999999999
SYS@orcl29> select sql_id,event,count(*) from v$active_session_history where sample_time between to_date('2017-11-24 04:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2017-11-24 06:00:00','yyyy-mm-dd hh24:mi:ss') and event like '%dblink%' group by sql_id,event order by 3 desc,1;
SQL_ID EVENT COUNT(*)
--------------- ------------------------------ ----------
5hv12nch90c64 SQL*Net message from dblink 18820
3dvhmxnrh4pku SQL*Net message from dblink 18321
7gtx71zyhtkza SQL*Net message from dblink 2431
c6fk526c9fxyu SQL*Net message from dblink 2429
5hv12nch90c64 SQL*Net more data from dblink 602
3dvhmxnrh4pku SQL*Net more data from dblink 552
1v43bvmr5jf9m SQL*Net message from dblink 163
078f2p3q4y0p4 SQL*Net message from dblink 161
c6fk526c9fxyu SQL*Net more data from dblink 37
SQL\*Net message from dblink 24
7gtx71zyhtkza SQL*Net more data from dblink 23
4vk24sfq0hbxs SQL*Net message from dblink 13
55xu2ckbah1st SQL*Net message from dblink 13
078f2p3q4y0p4 SQL*Net more data from dblink 1
1v43bvmr5jf9m SQL*Net more data from dblink 1
15 rows selected.
SYS@orcl29> select sql_id,event,count(*) from v$active_session_history where sample_time between to_date('2017-11-24 06:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2017-11-24 07:00:00','yyyy-mm-dd hh24:mi:ss') and event like '%dblink%' group by sql_id,event order by 3 desc,1;
no rows selected
Now,how to analyze it continually for me?
Please giving me some effective suggestion,thanks
Best Regards
Quanwen Zhao