sql monitor
From: Henry Poras <henry.poras_at_gmail.com>
Date: Mon, 18 May 2020 14:57:45 -0400
Message-ID: <CAK5zhL+4iFf5hBKxnza_HhS5Y+wnt4JHuxShzmMLb2did_Q8aQ_at_mail.gmail.com>
Has anyone gotten "alter systems set events 'sql_monitor [sql:xxxxxxx] force-true'" to work? I'm on 12.1.0.2, enabled monitoring for a sql_id whose plan is greater than the default for monitoring (> 300 lines). I can see the sql running, but it isn't being monitored.
Date: Mon, 18 May 2020 14:57:45 -0400
Message-ID: <CAK5zhL+4iFf5hBKxnza_HhS5Y+wnt4JHuxShzmMLb2did_Q8aQ_at_mail.gmail.com>
Has anyone gotten "alter systems set events 'sql_monitor [sql:xxxxxxx] force-true'" to work? I'm on 12.1.0.2, enabled monitoring for a sql_id whose plan is greater than the default for monitoring (> 300 lines). I can see the sql running, but it isn't being monitored.
Anyone else see this?
Thanks.
Henry
--http://www.freelists.org/webpage/oracle-l Received on Mon May 18 2020 - 20:57:45 CEST