Memory used by a Query
well I am confused with the multiple memory columns in the monitor tables.
As of now I assume the memory used by a query is the "memory_inuse_kb" column of "resource_acquisitions" table into number of nodes.
1 Gb in that col and 10 nodes is 10 Gb of memory used in the query executiong
confuses which one to consider as memory utilized.
The total memory reserved by the query is available in RESOURCE_ACQUISITIONS.MEMORY_INUSE_KB. The difference between RESOURCE_ACQUISITIONS.MEMORY_INUSE_KB and QUERY_PROFILES.RESERVED_EXTRA_MEMORY is the "essential memory."
- RESOURCE_ACQUISITIONS.MEMORY_INUSE_KB is the total memory acquired.
- QUERY_PROFILES.RESERVED_EXTRA_MEMORY is the unused portion of the acquired memory.
- The difference gives you the memory in use.