PGA Memory Leak Using PL/SQL JSON Functions (Doc ID 3047893.1)

Last updated on SEPTEMBER 16, 2024

Applies to:

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

On : 19.24.0.0.0 version, XML Database

PGA memory leak using PL/SQL JSON functions

Customer package that is calling the function JSON_OBJECT_T.TO_STRING.

Failing handle JSON objects

0xf1e2b678 9 type body SYS.JDOM_T.PARSE
0x7c9d81c0 115 type body SYS.JSON_OBJECT_T.PARSE

*** 2024-08-23T20:24:12.595568+02:00
87% 1617 MB, 29564920 chunks: "qjsnCrPls " <<<<<
qjsngGetSessio ds=0x7f0ddaf4f2b8 dsprt=0x7f0ddb84fdb8

	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

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