|
Index >
ORACLE Server Parameters >
sort_area_retained_size
sort_area_retained_size
Oracle 11.1.0:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 10.2.0:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 10.1.0:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 9.2.0:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 8.1.7:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 8.0.6:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 7.3.4:
| Parameter Name: | sort_area_retained_size
| | Description: | size of in-memory sort work area retained between fetch calls
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Related Error Messages:
ORA-01220: file based sort illegal before database is openCause: A query issued against a fixed table or view required a temporary segment for sorting before the database was open. Only in-memory sorts are supported before the database is open.Action: Re-phrase the query to avoid a large sort, increase the values of the SORT_AREA_SIZE and/or SORT_AREA_RETAINED_SIZE initialization parameters to enable the sort to be done in memory.
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ sort_area_retained_size ]
on the Oracle FAQ.
| 
