Oracle hidden sort parameters Don Burleson

Note: Oracle hidden parameters are undocumented and unsupported by Oracle.
Make sure that you thoroughly test all hidden parameters before placing them in your production environment.

Parameter Name                            Description

----------------------------------------- ---------------------------------------------------------

_sort_elimination_cost_ratio              cost ratio for sort eimination under first_rows mode

_sort_multiblock_read_count               multi-block read count for sort

_sort_space_for_write_buffers             tenths of sort_area_size devoted to direct write buffers

_sortmerge_inequality_join_off            turns off sort-merge join on inequality

_spin_count                               Amount to spin waiting for a latch

_sql_connect_capability_override          SQL Connect Capability Table Override

_sql_connect_capability_table             SQL Connect Capability Table (testing only)

_sqlexec_progression_cost                 sql execution progression monitoring cost threshold