Re: sql monitor

Hi Henry

I have been very often confronted to non-monitored very big execution plans and the the reliable fix I have alaways used is to increase the *_sqlmon_max_planlines* parameter:

https://hourim.wordpress.com/category/sql-monitor/

I haven't experienced any bad side effects induced by increasing this parameter

And the funny thing is that, if your query is running and not monitored, it suffices to increase the _sqlmon_max_planlines parameter and you will get immediately your monitoring report as if it has been monitored from the beginning of the *execution*.

Best regards
Mohamed

Le lun. 18 mai 2020 à 21:52, Henry Poras <henry.poras_at_gmail.com> a écrit :

> 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
>>
>

-- 

Houri Mohamed

Oracle DBA-Developer-Performance & Tuning

Member of Oraworld-team <http://www.oraworld-team.com/>

Visit My         - Blog <http://www.hourim.wordpress.com/>

Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*

My Twitter <https://twitter.com/MohamedHouri>      - MohamedHouri
<https://twitter.com/MohamedHouri>

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