Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XML Unnesting and In Memory issue

I have a source table in oracle that contains a column (Nclob) that have XML messages and my target is BW data souce

I build my job like that

Source Table------Quey1 (to convert to varchar)-------------Query2(Unnest XML using extract_xml)-----------------BW Target

I successfully running the job with small test data in source (About 100,000 records) takes about 30 minutes

But when I running with the actual table contains about 140000000 it takes so long time my be more than 12 hours and never ending and it is affect the job server so I decide to kill the job

I checked the log I found that the job running in im memory mode instead of peagable because it is nested schema

I need help to enhance this job and let running successfully

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question