DBA_HIST_PROCESS_MEM_SUMMARY

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Sun, 24 Nov 2019 19:02:35 +0000
Message-ID: <BL0PR11MB31884CA7583CF2836B6C5BC9F44B0_at_BL0PR11MB3188.namprd11.prod.outlook.com>



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:02:35 CET

Original text of this message