Enforcing a specific hash on a specific sql id
Oracle database
version: 19.19.0.0.0
For a batch series of jobs, we have a job that will often use several threads to execute a series of inserts. The last time this batch job was run, it had 215 snap ids, most of which were using a specific hash tag that guaranteed a faster result. 17 of those 215 were using an incorrect hash tag, which slowed the entire job. when using the correct hash, each thread takes seconds, or minutes, to execute. when using the incorrect hash, it takes half an hour or longer. Several times we've had to manually force this sql id to