Re: sql monitor

From: Martin Berger <>
Date: Mon, 18 May 2020 21:43:58 +0200
Message-ID: <>

Hi Henry,

It seems, information oracle shares regarding underscore parameters is vague as always.
A quite good source is  .
There Maria states, you can enforce monitoring with force=true , but then immediately the limits are explained.
I read id the way, by force=true, sqlmonitoring is "basically" triggered. Then it still follows all the rules & limitations, e.g. _sqlmon_max_planlines.

This all is only my interpretation. Still I'd recommend to increase _sqlmon_max_planlines. Maybe you can limit it to the sessions in question to limit it's impact.


Am Mo., 18. Mai 2020 um 20:59 Uhr schrieb Henry Poras <

> 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

Martin Berger                Oracle ♠ _at_martinberx <>

Received on Mon May 18 2020 - 21:43:58 CEST

Original text of this message