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?
nice and clear demo thanks sir
Tuning advisor before and after stale stats on the same table was good 👍
Very good demo and nice and clear explanation ...Sir....Thanks a lot ..!!!
Thanks Mallik it was helpful 🙂
very good demo
Sir can you please share video oracle 11.2 to PostgreSQL 13 migration
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?
Real time statistics 19c new feature
Is there any difference between sqlrpt. sql and this method?
Very helpful viedo
Glad you think so!
Is there any difference between this method and running the sqltrpt.sql SQL advisory?
OR both are same?
sqltrpt script will internally do the same things so no need to create manually tuning tasks
Good Explanation !!
Thanks
Awesome !!!!
❤
Helpful!
Glad you think so!