Timur Akhmadeev's Avatar

Timur Akhmadeev

@tmmdv.bsky.social

Oracle Apps Database Consultant at Pythian. Views are my personal opinion.

89 Followers  |  37 Following  |  75 Posts  |  Joined: 29.10.2024  |  2.093

Latest posts by tmmdv.bsky.social on Bluesky

As far as I remember itโ€™s available via sql test case builder. Havenโ€™t checked in a while.

28.10.2025 10:30 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

Do not like that (also, the way to get the traces)

27.10.2025 10:03 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Preview
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โ€ฆ

Missed some sessions at @OracleAIWorld? Here's the 2025 mega download of session content. Enjoy!
connor-mcdonald.com/2025/10/21/t...

21.10.2025 23:21 โ€” ๐Ÿ‘ 7    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image Post image

tabhisthybrid.sql: Display Oracle hybrid histograms and filter cardinality estimates

tanelpoder.com/posts/tabhis...

20.10.2025 13:59 โ€” ๐Ÿ‘ 4    ๐Ÿ” 3    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
SQL Tuning Guide Cursor sharing can improve database application performance by orders of magnitude.

Apparently Oracle Docs have embedded videos docs.oracle.com/en/database/...

14.10.2025 15:50 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image Post image

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

13.10.2025 14:01 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

One good thing with a MacOS is ability to use iPad as a second monitor.

13.10.2025 09:16 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

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?๐Ÿคฆโ€โ™‚๏ธ

08.10.2025 11:32 โ€” ๐Ÿ‘ 0    ๐Ÿ” 2    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Preview
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.โ€ฆ

Clop crew hits Oracle E-Business Suite users with fresh zero-day

06.10.2025 09:46 โ€” ๐Ÿ‘ 6    ๐Ÿ” 2    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 2
Post image Post image

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.

25.09.2025 11:09 โ€” ๐Ÿ‘ 3    ๐Ÿ” 1    ๐Ÿ’ฌ 4    ๐Ÿ“Œ 0

If you use Run Script in sqldeveloper, it works just like sqlplus

24.09.2025 14:07 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 3    ๐Ÿ“Œ 0

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

19.09.2025 15:10 โ€” ๐Ÿ‘ 4    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Troubleshooting Oracle Performance : Antognini, Christian: Amazon.es: Libros Troubleshooting Oracle Performance : Antognini, Christian: Amazon.es: Libros

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$.

15.09.2025 15:33 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Oracle Core: Essential Internals for vibe coders

08.09.2025 06:27 โ€” ๐Ÿ‘ 6    ๐Ÿ” 1    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Post image

What can I say, THANK YOU! #POUG2025 @luizafrompoland.bsky.social

06.09.2025 15:13 โ€” ๐Ÿ‘ 26    ๐Ÿ” 5    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

@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.

06.09.2025 11:11 โ€” ๐Ÿ‘ 5    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
Post image

Premiere at #POUG2025: @jloracle.bsky.social shows pictures on his slides ๐Ÿ˜

06.09.2025 10:03 โ€” ๐Ÿ‘ 6    ๐Ÿ” 2    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Timur at stage

Timur at stage

@tmmdv.bsky.social has a modern relationship with performance tools ( some is love, some is hate) - and shares his experience on #POUG2025

06.09.2025 09:03 โ€” ๐Ÿ‘ 7    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

Who is this mysterious man? Could it be @chandlerdba.bsky.social ? Strange happenings at #POUG2025 @sym42.bsky.social

05.09.2025 15:54 โ€” ๐Ÿ‘ 5    ๐Ÿ” 3    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image Post image

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!

05.09.2025 07:21 โ€” ๐Ÿ‘ 11    ๐Ÿ” 5    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 1
Post image

Sabrage with an axe. Yep, @pougorg.bsky.social

05.09.2025 07:17 โ€” ๐Ÿ‘ 6    ๐Ÿ” 2    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0
Post image

So it begins! @pougorg.bsky.social

05.09.2025 07:07 โ€” ๐Ÿ‘ 4    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Is there better news?
No.

03.09.2025 14:49 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

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)

03.09.2025 09:30 โ€” ๐Ÿ‘ 0    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

One minor comment: coalesce is not a function, itโ€™s an expression, which allows short circuit evaluation

03.09.2025 08:51 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0
AI Detector - Trusted AI Checker for ChatGPT, GPT5 & Gemini AI Content Detector and ChatGPT Detector, simple way with High Accuracy. AI Checker & AI Detector Free for AI GPT Plagiarism by ZeroGPT.

This one zerogpt.com but there are many other similar tools for AI detection. I see 87% of AI generated text as ~ plagiarism

29.08.2025 12:39 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 2    ๐Ÿ“Œ 0

You can do an online โ€œdirectorโ€™s cutโ€ 6h version later. No pressure though.

29.08.2025 12:03 โ€” ๐Ÿ‘ 2    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

Unfortunately it's 87%+ AI generated text so better not to promote it.

29.08.2025 11:31 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 1    ๐Ÿ“Œ 0

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".

28.08.2025 18:48 โ€” ๐Ÿ‘ 2    ๐Ÿ” 1    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

What if Automatic Error Mitigation leads to another internal error - will it fix itself

28.08.2025 19:53 โ€” ๐Ÿ‘ 1    ๐Ÿ” 0    ๐Ÿ’ฌ 0    ๐Ÿ“Œ 0

@tmmdv is following 20 prominent accounts