Under the shared sort model, all sortheap allocations are from the shared sort heap (sheapthres_shr), which is part of database shared memory (database_memory);sortheap defines the maximum number of private or shared memory pages possibly allocated f...
显示全部Under the shared sort model, all sortheap allocations are from the shared sort heap
(sheapthres_shr), which is part of database shared memory (database_memory);
sortheap defines the maximum number of private or shared memory pages possibly allocated for an operation.
不管shared sort model or private sort model, sortheap 都是要定义的, 因为它决定:每个sort操作最大可以allocate多少sort memory。 自己画个图可能更清楚些。
收起