This content has been marked as final. Show 4 replies
First, it doesn't free memory when it is done, and it uses it a lot.I've already loaded 100MB files in less than 30s using this technique.
Second, it lasts an eternety to insert all the data.
Does anybody have any idea how to optimize it?
Please post execution plan and exact db version.
How many rows are there? Is the SELECT alone slow as well?
Is the XQuery expression really as simple as 'xml/schema/path'?
Version: Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - Production
select clause is really fast, so that is not the issue.
It looks like insert clause is creating this delay. What do you think?
i have aprox. 500 000 records in xml and 10 er tables.
Why is inserting this records also creating memory leak?
It looks like insert clause is creating this delay. What do you think?Any trigger on the table?
How many blocks for the table segment? Empty blocks?
Does the APPEND hint help?
Why is inserting this records also creating memory leak?Which memory area are you talking about?
How do you monitor this leak?
yes, i have a before insert trigger. this could be stopping it. I will test the trigger code..
Append hint doesn't make any big difference. It tok 1:36 min for 12000 records.
I have observerd memory usage in task manager and i can see clearly that useg is rising while inserting and not going back to starting point.