Hi Sir, Kindly upload a video of " HOW TO CHANGE PLAN HASH VALUE OF A QUERY IF IT TAKES BAD PLAN HASH VALUE INSTAEAD OF REGULAR " and explain it if any impact on execution query.
Flush sql id from memory and run it again, it may pic good plan in next execution. If not gather stats all the tables involved in the sql query and run a sql tuning adviser, it may suggest to cement a good execution plan.
Very detailed description and probably the best one
u explained very deeply, thanks
Thanks keep watching!
Nice video 👍
Stay connected
Thanks sir
Welcome
awesome video
Thank you!
Do you train the DBA? When will your batch start
Please check our website for pre-recorded video course and Xperiments:
www.dbagenesis.com/courses
Hi Sir,
Kindly upload a video of " HOW TO CHANGE PLAN HASH VALUE OF A QUERY IF IT TAKES BAD PLAN HASH VALUE INSTAEAD OF REGULAR " and explain it if any impact on execution query.
Flush sql id from memory and run it again, it may pic good plan in next execution. If not gather stats all the tables involved in the sql query and run a sql tuning adviser, it may suggest to cement a good execution plan.
Doesn't log switch causes ckpt process to invoke???
Yes, it does