Database Tuning (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center