V$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL provides detailed information on dynamic PGA memory usage for each automatically captured snapshot.
| Column | Datatype | Description |
|---|---|---|
PID |
NUMBER |
Oracle process identifier |
SERIAL# |
NUMBER |
Oracle process serial number |
TIMESTAMP |
DATE |
Time at which the snapshot was taken |
SQL_ID |
VARCHAR2(13) |
Identifier for the relevant SQL statement |
TOTAL_MB |
NUMBER |
Total number of megabytes of PGA memory allocated at the time of the snapshot |
CATEGORY |
VARCHAR2(15) |
Category name. Categories include:
|
NAME |
VARCHAR2(26) |
PGA memory allocation comment. Small allocations may be grouped together with NAME set to Miscellaneous for performance reasons. |
HEAP_NAME |
VARCHAR2(15) |
Name of heap or heaps (if same name) containing the allocations |
BYTES |
NUMBER |
Bytes of PGA memory allocated in the process from heaps with the given heap name and with the given allocation comment |
ALLOCATION_COUNT |
NUMBER |
Number of allocations with the comment found in the process inside heaps with the given heap name |
HEAP_DESCRIPTOR |
RAW(4 | 8) |
If all the allocations are from one heap, then this is the address of the heap descriptor for that heap. Otherwise, this column is null. |
PARENT_HEAP_DESCRIPTOR |
RAW(4 | 8) |
If all the allocations are from one heap, then this is the address of the parent heap descriptor for that heap. Otherwise, this column is null. If the heap has no parent, the value is zero. |
MOST_RECENT |
NUMBER |
Oracle process identifier (PID) for most recent snapshot |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
|