My Oracle Support Banner

HOW TO DEBUG ABSTRACT LOB PGA MEMORY ALLOCATION (Doc ID 2780987.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5.0 to 19.11.0.0.0 [Release 10.2 to 19]
Information in this document applies to any platform.

Goal

This document applies to Oracle Database - Enterprise Edition - Version 9.2.0.5 to 19.11.0.0.0 [Release 9.2 to 19.11] 
It explains how to diagnose memory allocation generated by abstract LOB. Abstract LOBs are temporary lobs returned from 
queries involving XMLType columns. 
As described in the note 1955135.1 pga allocated by abstract lob may not be released leading to pga memory exhaustion. 
This node provides a sample testcase to reproduce this scenario. It gives the instruction to dump and analyze the memory 
allocation. Do not execute this testcase in a production environment use it solely on test and training. 
To correctly manage the abstract lob pga memory allocation read the following  note  use 1955135.1 Best practices for 
XMLType Temporary LOB Usage carefully.	 

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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