Timur Akhmadeev
tmmdv.bsky.social
Timur Akhmadeev
@tmmdv.bsky.social
89 followers 37 following 73 posts
Oracle Apps Database Consultant at Pythian. Views are my personal opinion.
Posts Media Videos Starter Packs
Reposted by Timur Akhmadeev
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates

tanelpoder.com/posts/tabhis...
Any idea what the new (?) light blue color in the SQL Monitor reports mean? It's different between those displayed directly in the console, and the stored & opened ones. It looks as if it tries to show active steps, but does it incorrectly in the OCI console. 1 - in console, 2 - same rep stored
One good thing with a MacOS is ability to use iPad as a second monitor.
Reposted by Timur Akhmadeev
Looks like it's not available anymore, my SR regarding this was closed with something like "Internal bug was submitted for investigation, but hey, we got that alternate features "Look-up By Error or Error Code's First Argument" or "Search by Stack Trace" added which replace it.
For real?🤦‍♂️
ORA-600/ORA-7445 Troubleshooting tools on MOS are not working for me - at least since yesterday.
Normally yes. If it asks for a bind value when running this then it uses varchar2 and causes the issue. It looks as if this happens only if you try to Run Script with a single SQL. Once there is more than 1 statement, it doesn't ask for bind and all is good.
If you use Run Script in sqldeveloper, it works just like sqlplus
Have you noticed 23ai FREE background process naming changed from ora_xxxx_SID to db_xxxx_SID? Curious how many shell scripts out there are going to break due to this once (if) 23ai is going to be released
Interesting how tech books are increadibly cheap compared to video courses. TOP www.amazon.com/Troubleshoot... is the best compilation of everything you need to know about Ora perf in 99.9% cases. It's 99$/US, 52€/EU. AOT learn.tanelpoder.com/courses/adva... is most likely great too, but it's 2000$.
Troubleshooting Oracle Performance : Antognini, Christian: Amazon.es: Libros
Troubleshooting Oracle Performance : Antognini, Christian: Amazon.es: Libros
www.amazon.es
Reposted by Timur Akhmadeev
Oracle Core: Essential Internals for vibe coders
Reposted by Timur Akhmadeev
@pougorg.bsky.social was great and it’s time to go. Thank you @ora600pl.bsky.social and the whole team for making it a great place to be. All the best in your next decade. See you some day soon.
Reposted by Timur Akhmadeev
Premiere at #POUG2025: @jloracle.bsky.social shows pictures on his slides 😁
Reposted by Timur Akhmadeev
@tmmdv.bsky.social has a modern relationship with performance tools ( some is love, some is hate) - and shares his experience on #POUG2025
Reposted by Timur Akhmadeev
Who is this mysterious man? Could it be @chandlerdba.bsky.social ? Strange happenings at #POUG2025 @sym42.bsky.social
Reposted by Timur Akhmadeev
And so, the 10th @pougorg.bsky.social #POUG25 starts.
The axeman @ora600pl.bsky.social opening the celebratory champagne bottle the only logical way.
If you don't hear from me again know that I went out having the best of times!
Is there better news?
No.
Radiohead will play some shows across Europe in November and December 2025.

Tickets will only be accessible by registering on radiohead.com.

Registration opens at radiohead.com on Friday 5th Sept at 10am BST / 11am CEST and runs through until Sunday 7th Sept at 10pm BST/11pm CEST.
Even the docs are not correct at times. A function evaluates its parameters before the call, an expression does not. Try coalesce(1, 1/0)
One minor comment: coalesce is not a function, it’s an expression, which allows short circuit evaluation
A while ago, I came across an interesting NVL trick on Connor Mc'Donald's blog. tinyurl.com/yc6xkdcz
I found this example intriguing enough to explore it myself.
Let's check, what is smarter/faster: NVL, COALESCE or old good query with OR.
tinyurl.com/mr7jay2j
@connormcd.bsky.social
The Magical NVL Function
A while ago, I came across an interesting NVL trick on Connor Mc'Donald's blog . In his example, he compares a query that uses an optiona...
tinyurl.com
You can do an online “director’s cut” 6h version later. No pressure though.