Copy of Oracle FAQ ORACLE RECOVERY without DUL
ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD INFO | ORAFAQ SEARCH | ORAFAQ E-MAIL
 

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 10.0.1:

Paramter 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:

Paramter 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.

ORAFAQ HOME | ORAFAQ ASK QUESTION | ORAFAQ ADD FAQ | ORAFAQ SEARCH | ORAFAQ E-MAIL
All content of this page is copy from www.orafaq.com