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:
mallik034.blog...
#19c #SQL #Performce #Tuning #Instance #Database #Administration #Exadata #oracle #RAC #Satndalone
Regards,
Mallikarjun Ramadurg
Mobile: [phone]
WhatsApp: [phone]

[@theinttheintthu5835]

nice and clear demo thanks sir

[@rajununna6939]

Very good demo and nice and clear explanation ...Sir....Thanks a lot ..!!!

[@Kensoftinfotech]

Tuning advisor before and after stale stats on the same table was good 👍

[@sivaprasad4691]

Sir can you please share video oracle 11.2 to PostgreSQL 13 migration

[@tracker5574]

Is there any difference between sqlrpt. sql and this method?

[@dileepreddy5624]

Thanks Mallik it was helpful 🙂

[@prasadbatikeru8250]

In real world situations there might be hundreds of DML statements will be executed on multiple tables , so there are possibilities that the table will be in stales status and it’s not possible to gather statistics regularly. How do we address this kind of problems with Oracle?

[@VismoTechnologies]

Real time statistics 19c new feature

[@ericksonezekiel4104]

very good demo

[@satyaprasad2009]

Very helpful viedo

[@VismoTechnologies]

Glad you think so!

[@arifansari42]

Is there any difference between this method and running the sqltrpt.sql SQL advisory? OR both are same?

[@MOBILEEVOLUTION123]

sqltrpt script will internally do the same things so no need to create manually tuning tasks

[@neerajgupta1140]

Good Explanation !!

[@VismoTechnologies]

Thanks

[@mayurrahate]

Helpful!

[@VismoTechnologies]

Glad you think so!

[@meghakaradi]

❤

[@syedsami6416]

Awesome !!!!