Database Tuning (MOSC)

MOSC Banner

SQL Optimization Strategies

edited May 7, 2024 12:27PM in Database Tuning (MOSC) 5 commentsAnswered

Hello,

In an Oracle 19c database we have vendor jobs scheduled 24\7. We cannot change the SQL of these jobs. Its sometimes hard to determine the elapse time executed SQL takes and if it is the best it can be.

1. How can I identify SQL (and corresponding SQL_IDs) that runs longer then 30 minutes?

2. Once identified, what are current strategies to get the identified (SQL_IDs) to run optimally?

Thank you,

Michael

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