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 18.104.22.168 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|