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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx>:
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@xxxxxxxxx @martinberx <https://twitter.com/martinberx>
^∆x http://berxblog.blogspot.com