Hello Amir,
I would do further analysis before opening an Oracle SR and struggling with
support.
Please check my paper for more details about how to drill-down deeper (starting
on page 17 - section "Non-SQL category"):
http://www.soocs.de/public/talk/161115_DOAG2016_Hacking_Oracles_Memory_About_Internals_Troubleshooting_PDF.pdf
Best Regards
Stefan Koehler
Independent Oracle performance consultant and researcher
Website: http://www.soocs.de
Twitter: @OracleSK
"Hameed, Amir" <Amir.Hameed@xxxxxxxxx> hat am 24. November 2019 um 21:04--
geschrieben:
Thanks Jonathan. It seems like an Oracle SR issue.
Regards,
Amir
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Jonathan Lewis
Sent: Sunday, November 24, 2019 2:16 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: DBA_HIST_PROCESS_MEM_SUMMARY
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Hameed, Amir <Amir.Hameed@xxxxxxxxx>
Sent: 24 November 2019 19:02
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
