Re: sql monitor

Martin,

Thanks. My interpretation was a bit different. I thought, well, if you need to set the underscore parameters, then why have the 'alter system' command. At that point, everything will be Monitored automatically anyway.

Henry

On Mon, May 18, 2020 at 3:44 PM Martin Berger <martin.a.berger_at_gmail.com> wrote:

> 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