Re: sql monitor

Hi Henry,

It seems, information oracle shares regarding underscore parameters is vague as always.
A quite good source is
https://sqlmaria.com/2017/08/01/getting-the-most-out-of-oracle-sql-monitor/  .
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.

hth,
 berx

Am Mo., 18. Mai 2020 um 20:59 Uhr schrieb Henry Poras <henry.poras_at_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
>
>

-- 
Martin Berger                Oracle ♠
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com

--
http://www.freelists.org/webpage/oracle-l