My THREE rules for SQL TUNING
Vložit
- čas přidán 5. 09. 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
I like that saying "the trolley from hell" ... 🙂
Thank you for sharing your large experience. I agree totally with this methodology.
Thanks for watching!
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!
Connor always saving the day
Very helpful explanation
Glad it was helpful!
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
11:17 would love to see a short demo with SPM.
Good coverage here by our Optimizer Product Manager czcams.com/video/OJog42VkcBM/video.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!