My Oracle Support Banner

Memory Leak When Using Database Link to Copy a Table with Binary XMLType (Doc ID 1448321.1)

Last updated on MARCH 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


We have seen a memory leak while inserting data from table with XMLType column over DB_LINK.

We are seeing increase in session PGA/UGA memory with increase in number of inserted rows into a table with XMLType, for example 30,000 rows of small xml documents session PGA/UGA grows over 2 GB.


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
 Workaround:  - workaround is to use a cursor to fetch and then insert

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.