RE: DBA_HIST_PROCESS_MEM_SUMMARY

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: _at_OracleSK

> "Hameed, Amir" <Amir.Hameed_at_xerox.com> 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_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
>
>
> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l