SQL Optimization Strategies
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