|
Index >
ORACLE Server Parameters >
_hash_multiblock_io_count
_hash_multiblock_io_count
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: | _hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.2.0:
| Parameter Name: | _hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 10.1.0:
| Parameter Name: | _hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 9.2.0:
| Parameter Name: | _hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.1.7:
| Parameter Name: | hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 8.0.6:
| Parameter Name: | hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
Oracle 7.3.4:
| Parameter Name: | hash_multiblock_io_count
| | Description: | number of blocks hash join will read/write at once
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | IMMEDIATE
|
This parameter is not documented and should not be used.
Search for more info about
[ _hash_multiblock_io_count ]
on the Oracle FAQ.
|
