Automatic SQL Tuning Adviser Oracle Database Performance Tuning

Channel Avatar
Comment
X
Share
Automatic SQL Tuning Adviser Oracle Database Performance Tuning
Automatic SQL Tuning Adviser Oracle Database Performance Tuning
Optimizer — Will generate and pick execution plan
Suppose Stale Table or Wrong statistics of a table

1. Statistical Analysis
2. Accessing Path (Using Index or not)

High level Steps:
Create Tuning Task:
Execute Tuning Task:
Status of Tuning Task:
Display the Recommendation:
Drop the Tuning Task:

Reference:
https://mallik034.blogspot.com/2021/11/automatic-sql-tuning-adviser.html

#19c #SQL #Performce #Tuning #Instance #Database #Administration #Exadata #oracle #RAC #Satndalone

Regards,
Mallikarjun Ramadurg
Mobile: 91 9880616848
WhatsApp: 91 9880616848

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *