How to set event 44410?
mrzliSep 3 2008 — edited Sep 3 2008Hello,
Acording to Metalink Note 4277241.8:
xmlagg() with a GROUP BY can fail with ORA-22813 if the result is too large.
This is normal and expected as there is a hard coded limit on the result
size BUT this fix allows event 44410 to be set which uses a different method
to evaluate the XMLAGG(). The event is disabled by default.
But it doesn't say how to set that event.
I was trying with ALTER SESSION SET EVENTS '44410 ...' but I'm not sure if this is the right way (and what are other parameters).
Thanks,
Hrvoje.