Automatic SQL Tuning Adviser || Oracle Database Performance Tuning
12.5 هزار بار بازدید -
3 سال پیش
-
Optimizer --- Will generate and
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/1...
#19c #SQL #Performce #Tuning #Instance #Database #Administration #Exadata #oracle #RAC #Satndalone
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
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/1...
#19c #SQL #Performce #Tuning #Instance #Database #Administration #Exadata #oracle #RAC #Satndalone
Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848
3 سال پیش
در تاریخ 1400/09/02 منتشر شده
است.
12,592
بـار بازدید شده