Index >
ORACLE Server Parameters >
_smm_auto_max_io_size
_smm_auto_max_io_size
NOTE: This is an internal Oracle parameter. Do NOT use it unless instructed
to do so by Oracle Support. Playing with this parameter may be harmful.
Oracle 11.1.0:
Parameter Name: | _smm_auto_max_io_size
| Description: | Maximum IO size (in KB) used by sort/hash-join in auto mode
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
Parameter Name: | _smm_auto_max_io_size
| Description: | Maximum IO size (in KB) used by sort/hash-join in auto mode
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
Parameter Name: | _smm_auto_max_io_size
| Description: | Maximum IO size (in KB) used by sort/hash-join in auto mode
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
Parameter Name: | _smm_auto_max_io_size
| Description: | Maximum IO size (in KB) used by sort/hash-join in auto mode
| Type: | NUMBER
| Obsoleted: | FALSE
| Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.1.7:
No such parmeter in Oracle 8.1.7.
Oracle 8.0.6:
No such parmeter in Oracle 8.0.6.
Oracle 7.3.4:
No such parmeter in Oracle 7.3.4.
This parameter is not documented and should not be used.
Search for more info about
[ _smm_auto_max_io_size ]
on the Oracle FAQ.
|