|
The below is current test database config.
Application support layer heap size (4KB) (ASLHEAPSZ) = 15
Max requester I/O block size (bytes) (RQRIOBLK) = 32767
Query heap size (4KB) (QUERY_HEAP_SZ) = 2000
As far as I know, query_heap_sz gives the max value of the heap tht
handles blocking cursors, and communication between local agent and
db. The RQRIOBLK is the max size of the block memory that can be
requested by application.
The aslheapsz is the initial value of query_heap_sz, this is related
as, the query_heap being 5 times larger than this.
Is this correct understanding?
Also, since 15 is value of aslheapsz, how big can a blocking cursor
grow? Please give me an idea about this set.
Thanks
Arun
| 
