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