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