RE: DBA_HIST_PROCESS_MEM_SUMMARY
Date: Sun, 24 Nov 2019 20:04:30 +0000
Message-ID: <BL0PR11MB318819E665112038EBB2DE09F44B0_at_BL0PR11MB3188.namprd11.prod.outlook.com>
Thanks Jonathan. It seems like an Oracle SR issue.
Regards,
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
Hi,
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
Amir
-----Original Message-----
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Jonathan Lewis
Sent: Sunday, November 24, 2019 2:16 PM
To: oracle-l_at_freelists.org
Subject: Re: DBA_HIST_PROCESS_MEM_SUMMARY
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
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
---------- --------------- ------------- --------------- --------------- --------------- --------------- ---------------- --------------- -----------------
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
--
http://www.freelists.org/webpage/oracle-l
Received on Sun Nov 24 2019 - 21:04:30 CET