My Oracle Support Banner

WRONG INFORMATION IN ORA-04030 TRACE FILE( SHOWS SGA INSTEAD OF PGA ) (Doc ID 1454023.1)

Last updated on SEPTEMBER 24, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 11.2.0.3 [Release 10.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Goal

The ORA-4030 is an error in PGA. The content of v$pgastat is being dumped in the incident trace file in 11g. But the heading shows "Global SGA Info" instead of "Global PGA Info". This might misguide to take appropriate action to address the error.

Example trace file:


INSTANCE-WIDE PRIVATE MEMORY USAGE SUMMARY ------------------------------------------ Dumping Work Area Table (level=1) =====================================   Global SGA Info  ==========> This should be "Global PGA Info"    ---------------      global target:     5344 MB      auto target:        334 MB      max pga:           1068 MB      pga limit:         2137 MB      pga limit known:  0      pga limit errors:     0      pga inuse:        14630 MB      pga alloc:        16200 MB      pga freeable:        89 MB      pga freed:        1108459 MB      pga to free:          0      broker request:       0      pga auto:             0 MB      pga manual:           0 MB      pga alloc  (max): 16205 MB      pga auto   (max):  4268 MB      pga manual (max):     1 MB      # workareas     :     0      # workareas(max):   294


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!


In this Document
Goal
Solution

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