Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

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 open
    Cause: 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.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US