My THREE rules for SQL TUNING

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

[@QueryTuner]

I like that saying "the trolley from hell" ... 🙂

[@theroc1000]

Thank you for sharing your large experience. I agree totally with this methodology.

[@DatabaseDude]

Thanks for watching!

[@asrytube]

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.

[@DatabaseDude]

Tim and Steve are both good friends!

[@ricardooberdanpereira793]

Connor always saving the day

[@dpu11]

Very helpful explanation

[@DatabaseDude]

Glad it was helpful!

[@mndfvck]

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.

[@DatabaseDude]

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

[@dmy0]

11:17 would love to see a short demo with SPM.

[@DatabaseDude]

Good coverage here by our Optimizer Product Manager czcams.com/video/OJog42VkcBM/video.html

[@habeebahmed4904]

Very Good Explanation indeed.... Will definitely keep a tab on the mentions :)

[@DatabaseDude]

Glad it was helpful!

[@user-hh3dj5uh9v]

Thanks for sharing your knowledge!

[@DatabaseDude]

Glad it was helpful!

[@nagarajuneeriganti8101]

Very informative

[@DatabaseDude]

Glad you think so!

[@marcinbadtke]

thank you

[@DatabaseDude]

You're welcome

[@navarrodba]

7:48 This was really helpful, thank you!

[@DatabaseDude]

Glad it was helpful!