My THREE rules for SQL TUNING
ฝัง
- เผยแพร่เมื่อ 12 ก.ย. 2024
- Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
www.oracle.com...
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #sql #performance
Thank you for sharing your large experience. I agree totally with this methodology.
Thanks for watching!
I like that saying "the trolley from hell" ... 🙂
Hi, thank you for the amazing quick tips. I've always watched tips from steve feuerstein or oracle-base. I am your new subscriber and really enjoy your stuff.
Hope you'd not be offended mentioning their names on your video.
Tim and Steve are both good friends!
Thanks for sharing your knowledge with us. Exactly today we had a case in our exadata environment where a statement is taking massively taking longer time and we dont know why. I shared your video (especially the dynamic_sampling part) to our collegue to review and think about this.
Core "Problem: Huge more buffer gets with the same execution plan.
One thing to check - look at if there's a lot of transactional activity on the same table. Those buffer gets might be work undo-ing transactions for consistent read. Look at the "undo records applied" session stats to see if thats the case
Very helpful explanation
Glad it was helpful!
Connor always saving the day
11:17 would love to see a short demo with SPM.
Good coverage here by our Optimizer Product Manager th-cam.com/video/OJog42VkcBM/w-d-xo.html
Very Good Explanation indeed.... Will definitely keep a tab on the mentions :)
Glad it was helpful!
Thanks for sharing your knowledge!
Glad it was helpful!
Very informative
Glad you think so!
thank you
You're welcome
7:48 This was really helpful, thank you!
Glad it was helpful!