The SQL_ID is just a different representation of the internal hash value that is calculated for every SQL statement. We often use it to dig into the performance views once we have run a statement, but can we know what the SQL_ID for a statement will be in advance?
Important Update: Check out the blog post at https://connor-mcdonald.com/2021/10/04/get-the-sql_id-for-a-sql-statement-before-you-run-it/ for an easier method to get the SQL_ID.
Follow me!
blog: https://connor-mcdonald.com
twitter: https://twitter.com/connor_mc_d
The Podcast!
https://podcasts.apple.com/au/podcast/the-spoken-nerd/id1552316025
https://open.spotify.com/show/5dqVVftZhw0lu1fnX20TiP
Subscribe for new tech videos every week
Other social media channels here: https://linktr.ee/connor
A free Oracle database forever ?! Oh yes indeed!
https://www.oracle.com/cloud/free
Music: Night Owl (Broke For Free), Kevin Mcleod (incomptech), Dyalla
#oracle #sql #performance
0 Comments