- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Hint to enforce "temp segment merge"
When doing a direct path load the database has two different basic strategies, temp segment merge and brokered load.
There is a hint to enable brokered load (HWM_BROKERED ) but there is no hint to switch it off.
There is no hint to enable temp segment merge.
For some highly parallel inserts temp segment merge is the best strategy. If the inserts grows the segment quickly, brokered load can result in "enq: HV contention" waits.
The only way brokered load can be switched off is the hidden parameter "_INSERT_ENABLE_HWM_BROKERED" on system level.
This option is almost useless, because HWB is the better overall stategey. Only for some selected statements TSM is perferrable.