Thanks, @3:13 to 3:40 got confused. You mentioned the table which is not being touched mostly should have latest stats and again you said the table getting touched(Insert,update,del etc) on daily base and trying to do stats will have perf issue. Please help with some eg.
Hi Ankush, please explain how to proactively fix swap and cpu spikes.everytime checking and informing apps team and cancel session.its boring job.please reply
My interview question: if we confirm statiscs are statle state but If I run gathering statistics job on production environment with peak time, with out informing application team, it's locking any table performance. Hope you have a moment to confirm.
Hi sir
Aasa konsa parameter hai jo parameters ki maximum values dikhata hai????
Thanks, @3:13 to 3:40 got confused. You mentioned the table which is not being touched mostly should have latest stats and again you said the table getting touched(Insert,update,del etc) on daily base and trying to do stats will have perf issue. Please help with some eg.
He is wrong.
Table which is frequent update/delete/insert needs to stats collected,if the table data is not changing ,u can lock the stats .
Yes exactly. He is confused.
@@balaaws1991 correct
@@balaaws1991correct
Thanks bro.... make more videos like this...
Thank You!!
Thanks for the great video!
Thanks
Is oracle used in research works ?
Hi Ankush
Please can you provide more videos on multiple sql query to run using bash...
Sure 👍💯
great video can you do cbo vs rbo and more about performance tuning
Nice
Hi Ankush, please explain how to proactively fix swap and cpu spikes.everytime checking and informing apps team and cancel session.its boring job.please reply
tables with high DML should be candidates for statistic gathering.. do your DD first
👍👍👌
My interview question: if we confirm statiscs are statle state but If I run gathering statistics job on production environment with peak time, with out informing application team, it's locking any table performance. Hope you have a moment to confirm.
What was your answer,
Hi, Please remove the video and upload the correct version of it. People might be misunderstood and it affects your reputation.
Very Good Explain but is missing if you can show one or two Practically how to get the statistics of table or index.. thanks
Thanks