Index >
ORACLE Server Parameters >
sort_area_size
sort_area_size
Oracle 10.0.1:
Paramter Name: | sort_area_size
| Description: | size of in-memory sort work area
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 9.2.0:
Paramter Name: | sort_area_size
| Description: | size of in-memory sort work area
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 8.1.7:
Paramter Name: | sort_area_size
| Description: | size of in-memory sort work area
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 8.0.6:
Paramter Name: | sort_area_size
| Description: | size of in-memory sort work area
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 7.3.4:
Paramter Name: | sort_area_size
| Description: | size of in-memory sort work area
| 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.
ORA-01690: sort area size too small
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ sort_area_size ]
on the Oracle FAQ.
|