Re: DBA_HIST_PROCESS_MEM_SUMMARY
Date: Sun, 24 Nov 2019 19:15:43 +0000
Message-ID: <CWXP265MB1750712558441AB9B9E26A4AA54B0_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>
The last time I saw numbers like this it was tracking down a bug (or handful of bugs) in 10.2.0.5, mostly fixed by 11.1.0.6 ( https://jonathanlewis.wordpress.com/2009/06/07/pga-leaks/ ) and the notes I took at the time suggested that "other" might - in some cases - relate to memory being allocated but not correctly reported for arrays inside pl/sql. The blog note includes an update on how you can get a closer look at the pga memory detail to see where the big numbers are coming from.
Regards
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Hameed, Amir <Amir.Hameed_at_xerox.com> Sent: 24 November 2019 19:02
To: oracle-l_at_freelists.org
Subject: DBA_HIST_PROCESS_MEM_SUMMARY
Hi,
Does anyone know what the PGA memory allocated to the “Other” category means? The DB version is 11.2.0.4.
https://docs.oracle.com/cd/E18283_01/server.112/e17110/statviews_4025.htm
I see the following when I query the view:
SNAP_ID CATEGORY NUM_PROCESSES NON_ZERO_ALLOCS USED_TOTAL ALLOCATED_TOTAL ALLOCATED_AVG ALLOCATED_STDDEV ALLOCATED_MAX MAX_ALLOCATED_MAX
---------- --------------- ------------- --------------- --------------- --------------- --------------- ---------------- --------------- -----------------
2873 Freeable 1006 1006 0 2,687,369,216 2,671,341 20,372,438 427,556,864
Other 1711 1711 8,117,841,298 4,744,501 4,460,369 111,588,414 111,588,414
PL/SQL 1709 1709 398,070,936 656,436,320 384,106 4,300,913 176,113,752 176,133,728
SQL 1690 1678 10,590,800,808 10,823,355,152 6,404,352 39,223,501 322,417,784 533,273,992
********** ---------------
sum 22,285,001,986
Thanks,
Amir
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 24 2019 - 20:15:43 CET