Re: sql monitor

From: Tanel Poder <>
Date: Tue, 19 May 2020 18:02:40 -0400
Message-ID: <>

The force=true for sql_monitor event is about enabling *immediate* monitoring for SQL statements that would otherwise get monitored after 5 seconds of (CPU+I/O wait) time. It would be similar to using a SQL patch to inject the MONITOR hint for that SQL_ID (although it uses a different mechanism).

It does not lift the _sqlmon_max_planlines restriction, so you'd need to increase that for your large plans.

Note that the sql_monitor force=true seems to be buggy in later versions - it works in 12c, but doesn't seem to do anything in 18c & 19c.

Tanel Poder

On Mon, May 18, 2020 at 2:59 PM Henry Poras <> wrote:

> Has anyone gotten "alter systems set events 'sql_monitor [sql:xxxxxxx]
> force-true'" to work? I'm on, 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
Received on Wed May 20 2020 - 00:02:40 CEST

Original text of this message