Timur Akhmadeev
@tmmdv.bsky.social
Oracle Apps Database Consultant at Pythian.
Views are my personal opinion.
Views are my personal opinion.
Reposted by Timur Akhmadeev
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)
tanelpoder.com/posts/oracle...
tanelpoder.com/posts/oracle...
November 10, 2025 at 5:52 AM
New scripts: vstat.sql & dstat.sql for showing Oracle Sysmetric history with 1-minute granularity (both from AWR and regular V$ views)
tanelpoder.com/posts/oracle...
tanelpoder.com/posts/oracle...
Reposted by Timur Akhmadeev
Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":
tanelpoder.com/2014/03/26/o...
tanelpoder.com/2014/03/26/o...
November 10, 2025 at 6:29 AM
Added a blog update about the V$PROCESS_MEMORY_DETAIL auto-population for processes with PGA growth to over 500MB. Enabled in Oracle 19.18+, so no "oradebug dump pga_get_detail" needed, just query the V$ views for a detailed "heapdump":
tanelpoder.com/2014/03/26/o...
tanelpoder.com/2014/03/26/o...
Do not like that (also, the way to get the traces)
October 27, 2025 at 10:04 AM
Do not like that (also, the way to get the traces)
Reposted by Timur Akhmadeev
Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy!
connor-mcdonald.com/2025/10/21/t...
connor-mcdonald.com/2025/10/21/t...
The AI World 2025 mega download!
We’ve all been there… You head over to the Session Catalog for AI World and you want to download the files for all of the sessions you have been to, and all of the sessions you have missed. Then yo…
connor-mcdonald.com
October 21, 2025 at 11:21 PM
Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy!
connor-mcdonald.com/2025/10/21/t...
connor-mcdonald.com/2025/10/21/t...
Reposted by Timur Akhmadeev
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates
tanelpoder.com/posts/tabhis...
tanelpoder.com/posts/tabhis...
October 20, 2025 at 1:59 PM
tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates
tanelpoder.com/posts/tabhis...
tanelpoder.com/posts/tabhis...
Apparently Oracle Docs have embedded videos docs.oracle.com/en/database/...
SQL Tuning Guide
Cursor sharing can improve database application performance by orders of magnitude.
docs.oracle.com
October 14, 2025 at 3:50 PM
Apparently Oracle Docs have embedded videos docs.oracle.com/en/database/...
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
October 13, 2025 at 2:01 PM
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
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?🤦♂️
For real?🤦♂️
ORA-600/ORA-7445 Troubleshooting tools on MOS are not working for me - at least since yesterday.
October 8, 2025 at 11:32 AM
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?🤦♂️
For real?🤦♂️
Reposted by Timur Akhmadeev
Clop crew hits Oracle E-Business Suite users with fresh zero-day
Clop crew hits Oracle E-Business Suite users with fresh zero-day
Big Red rushes out patch for 9.8-rated flaw after crooks exploit it for data theft and extortion
Oracle rushed out an emergency fix over the weekend for a zero-day vulnerability in its E-Business Suite (EBS) that criminal crew Clop has already abused for data theft and extortion.…
dlvr.it
October 6, 2025 at 9:46 AM
Clop crew hits Oracle E-Business Suite users with fresh zero-day
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
September 19, 2025 at 3:10 PM
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
September 15, 2025 at 3:33 PM
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$.
Reposted by Timur Akhmadeev
Oracle Core: Essential Internals for vibe coders
September 8, 2025 at 6:27 AM
Oracle Core: Essential Internals for vibe coders
Reposted by Timur Akhmadeev
What can I say, THANK YOU! #POUG2025 @luizafrompoland.bsky.social
September 6, 2025 at 3:13 PM
What can I say, THANK YOU! #POUG2025 @luizafrompoland.bsky.social
@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.
September 6, 2025 at 11:11 AM
@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 😁
September 6, 2025 at 10:03 AM
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
September 6, 2025 at 9:04 AM
@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
September 5, 2025 at 3:55 PM
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!
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!
September 5, 2025 at 7:21 AM
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!
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!
Sabrage with an axe. Yep, @pougorg.bsky.social
September 5, 2025 at 7:17 AM
Sabrage with an axe. Yep, @pougorg.bsky.social
Is there better news?
No.
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.
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.
September 3, 2025 at 2:49 PM
Is there better news?
No.
No.
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
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
September 3, 2025 at 8:51 AM
One minor comment: coalesce is not a function, it’s an expression, which allows short circuit evaluation
Unfortunately it's 87%+ AI generated text so better not to promote it.
August 29, 2025 at 11:31 AM
Unfortunately it's 87%+ AI generated text so better not to promote it.
Reposted by Timur Akhmadeev
Link to the topic in the Tuning Guide:
docs.oracle.com/en/database/...
Link to the VLDB paper Oracle wrote on the topic:
www.vldb.org/pvldb/vol16/...
P.S. I really enjoyed seeing paragraph 2.1 - "hints obligate the optimizer to honor actions they specify".
docs.oracle.com/en/database/...
Link to the VLDB paper Oracle wrote on the topic:
www.vldb.org/pvldb/vol16/...
P.S. I really enjoyed seeing paragraph 2.1 - "hints obligate the optimizer to honor actions they specify".
August 28, 2025 at 6:48 PM
Link to the topic in the Tuning Guide:
docs.oracle.com/en/database/...
Link to the VLDB paper Oracle wrote on the topic:
www.vldb.org/pvldb/vol16/...
P.S. I really enjoyed seeing paragraph 2.1 - "hints obligate the optimizer to honor actions they specify".
docs.oracle.com/en/database/...
Link to the VLDB paper Oracle wrote on the topic:
www.vldb.org/pvldb/vol16/...
P.S. I really enjoyed seeing paragraph 2.1 - "hints obligate the optimizer to honor actions they specify".
Reposted by Timur Akhmadeev
We live in the different worlds :) As a developer I find this dashboard distinctly unhelpful. Let's say I have an incident: p99 of resp time is above the targets. Will AAS tell us what ails those queries? Not really. This is the reason why we use SQL trace with extra tooling.
August 14, 2025 at 5:15 PM
We live in the different worlds :) As a developer I find this dashboard distinctly unhelpful. Let's say I have an incident: p99 of resp time is above the targets. Will AAS tell us what ails those queries? Not really. This is the reason why we use SQL trace with extra tooling.