|
Index >
ORACLE Server Parameters >
_small_table_threshold
_small_table_threshold
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: | _small_table_threshold
| | Description: | threshold level of table size for direct reads
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 10.2.0:
| Parameter Name: | _small_table_threshold
| | Description: | threshold level of table size for direct reads
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 10.1.0:
| Parameter Name: | _small_table_threshold
| | Description: | threshold level of table size for direct reads
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 9.2.0:
| Parameter Name: | _small_table_threshold
| | Description: | threshold level of table size for direct reads
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 8.1.7:
| Parameter Name: | _small_table_threshold
| | Description: | threshold level of table size for forget-bit enabled during scan
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 8.0.6:
| Parameter Name: | _small_table_threshold
| | Description: | threshold level of table size for forget-bit enabled during scan
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | DEFERRED
|
Oracle 7.3.4:
| Parameter Name: | _small_table_threshold
| | Description: | threshold level of table size for forget-bit enabled during scan
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | FALSE
| Can ALTER SYSTEM: | FALSE
|
This parameter is not documented and should not be used.
Search for more info about
[ _small_table_threshold ]
on the Oracle FAQ.
|
