XMLELEMENT ... XMLAGG terminates with an ORA-07445 [qmxtgFreeLob+12]
(Doc ID 1942074.1)
Last updated on JUNE 12, 2021
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 to 10.2.0.4 [Release 10.2]Information in this document applies to any platform.
Symptoms
A large XMLELEMENT...XMLAGG query terminates with an ORA-03113 and generates an intenal error logged in the alert.log:
Mon Nov 03 16:25:48 2014
Errors in file d:\oracle\admin\df\bdump\df_j000_9340.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [qmxtgFreeLob+12] [PC:0x55C9458] [ADDR:0x0] [UNABLE_TO_WRITE] []
Errors in file d:\oracle\admin\df\bdump\df_j000_9340.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [qmxtgFreeLob+12] [PC:0x55C9458] [ADDR:0x0] [UNABLE_TO_WRITE] []
Call stack from the trace file is:
qmxtgFreeLob qmxtkAggInitialize qxuag_trusted_call_init_wrap qxuag_trusted_initself
qxuag_trusted_eval qxuageag qergsFetch opifch2 opifch
qxuag_trusted_eval qxuageag qergsFetch opifch2 opifch
A simple XMLELEMENT...XMLAGG query such as below similarly terminates with the identical error:
SELECT XMLELEMENT ("leverancierExport", (xmlagg (XMLELEMENT ("leverancier")))) FROM dual;
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |