MIB Viewer

oramodDbCfgSORTAREASIZE

OBJECT-TYPE
1.3.6.1.4.1.546.16.4.10.1.1.1.24
Access
read-only
Status
mandatory
Sub-identifiers
0
Maximum Sort Area Size. Controls the amount of memory allocated to each process in the Process Global Area for any sorting activity (for multithreaded server this is allocated in the shared pool). When a process needs more memory than is available for a sort, disk space must be allocated in the temporary tablespace. Tuning is based on the transaction mix of the application. The default (O/S dependent) is adequate for most DB operations.
INTEGER (1..2147483647)