9.131 V$PROCESS_MEMORY_DETAIL
V$PROCESS_MEMORY_DETAIL
provides detailed information on dynamic PGA memory usage for each automatically captured snapshot.
Column | Datatype | Description |
---|---|---|
|
|
Oracle process identifier |
|
|
Oracle process serial number |
|
|
Time at which the snapshot was taken |
|
|
Identifier for the relevant SQL statement |
|
|
Total number of megabytes of PGA memory allocated at the time of the snapshot |
|
|
Category name. Categories include:
|
|
|
PGA memory allocation comment. Small allocations may be grouped together with |
|
|
Name of heap or heaps (if same name) containing the allocations |
|
|
Bytes of PGA memory allocated in the process from heaps with the given heap name and with the given allocation comment |
|
|
Number of allocations with the comment found in the process inside heaps with the given heap name |
|
|
If all the allocations are from one heap, then this is the address of the heap descriptor for that heap. Otherwise, this column is |
|
|
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 |
|
|
Oracle process identifier ( |
|
|
The ID of the container to which the data pertains. Possible values include:
|