Oracle8i Reference Release 2 (8.1.6) A76961-01 |
|
Initialization Parameters, 172 of 188
Parameter type: |
Integer |
Parameter class: |
Dynamic. Scope= |
Default value: |
Derived from |
Range of values: |
from the value equivalent of two database blocks to the value of |
|
|
Oracle may allocate multiple sort spaces of this size for each query. Usually, only one or two sorts occur at one time, even for complex queries. In some cases, however, additional concurrent sorts are required, and each sort keeps its own memory area. If the multi-threaded server is used, allocation is to the SGA until the value in |
|
Note: The default value as reflected in the |
|
See Also:
|
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|