select con_id,inst_id,event#,event,count(*) from gv$session where wait_class#<>6 and event NOT LIKE 'SQL*N%' group by con_id,inst_id,event#,event order by 5
*
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated
NAME DESCRIPTION VALUE ISDEFAULT ISMODIFIED ISADJUSTED
------------------------------------------------------------ ---------------------------------------------------------------------- ---------------------------------------- ---------- ---------- ----------
_report_capture_cycle_time Time (in sec) between two cycles of report capture daemon 60 TRUE false false
--节点1执行
alter system set "_report_capture_cycle_time"=0;
--节点1 alert
Mon Aug 05 10:50:33 2019
ALTER SYSTEM SET _report_capture_cycle_time=0 SCOPE=BOTH;
NAME DESCRIPTION VALUE ISDEFAULT ISMODIFIED ISADJUSTED
------------------------------------------------------------ ---------------------------------------------------------------------- ---------------------------------------- ---------- ---------- ----------
_report_capture_cycle_time Time (in sec) between two cycles of report capture daemon 0 TRUE system_mod false
show1 _param _report_capture_cycle_time