ON Resource Pool Memory Allocation Parameter
I had 2 question on Memory Allocation parameters:
Q1. What are the implications of setting MEMORYSIZE = 3G and MAXMEMORYSIZE = 3G on one pool?
Ans: My understanding is- if our query needs more resource then it CAN'T borrow additional resource from General pool.
Q2. For example, we have a pool with MEMORYSIZE = 1G, MAXMEMORYSIZE = 5G, and our query that needs 5G memory to complete.
a. How much memory will be borrowed from the General pool?
b. What if a query from this pool needs 6G?
Ans: a. 4G will be borrowed from general Pool
b. The resource pool will "REJECT" the query and it would show "ABORT" in resource_rejections system table.
Please clarify me if i am wrong. Thank you.