DBA_HIST_PROCESS_MEM_SUMMARY
DBA_HIST_PROCESS_MEM_SUMMARY displays historical information about dynamic PGA memory usage by named component categories for each process.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SNAP_ID |
NUMBER |
NOT NULL |
Unique snapshot ID |
DBID |
NUMBER |
NOT NULL |
Database ID for the snapshot |
INSTANCE_NUMBER |
NUMBER |
NOT NULL |
Instance number for the snapshot |
CATEGORY |
VARCHAR2(15) |
NOT NULL |
Category name. Categories include “SQL”, “PL/SQL”, “OLAP” and “JAVA”. Special categories are “Freeable” and “Other”. Freeable memory has been allocated to the process by the operating system, but has not been allocated to a category. “Other” memory has been allocated to a category, but not to one of the named categories |
IS_INSTANCE_WIDE |
NUMBER |
This column shows whether the process memory detail is for only this container or for the whole instance. If the value is 1, the detail is for the whole instance. Any other value is the container ID for the container to which the detail pertains, as seen in the CON_ID column. |
|
NUM_PROCESSES |
NUMBER |
Number of processes | |
NON_ZERO_ALLOCS |
NUMBER |
Number of processes with nonzero allocations | |
USED_TOTAL |
NUMBER |
Bytes of PGA memory used by the process for the category | |
ALLOCATED_TOTAL |
NUMBER |
Total number of bytes of PGA memory allocated by the process for the category. | |
ALLOCATED_AVG |
NUMBER |
Average number of bytes of PGA memory allocated by the process for the category | |
ALLOCATED_STDDEV |
NUMBER |
Standard deviation of the number of bytes of PGA memory allocated by the process for the category | |
ALLOCATED_MAX |
NUMBER |
Maximum bytes of PGA memory ever allocated by the process for the category | |
MAX_ALLOCATED_MAX |
NUMBER |
Maximum bytes of PGA memory that can be allocated by the process for the category | |
CON_DBID |
NUMBER |
The database ID of the PDB for the sampled session | |
CON_ID |
NUMBER |
The ID of the container that
|