Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set event 44410?

mrzliSep 3 2008 — edited Sep 3 2008
Hello,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2008
Added on Sep 3 2008
3 comments
984 views