Lightnews — Scholar-powered news

Timur Akhmadeev @tmmdv.bsky.social · 4h

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

Cursor sharing can improve database application performance by orders of magnitude.

docs.oracle.com

Timur Akhmadeev @tmmdv.bsky.social · 1d

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

Timur Akhmadeev @tmmdv.bsky.social · 1d

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

1 2

Reposted by Timur Akhmadeev

Piotr Wrzosek @pewu78.bsky.social · 6d

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?🤦‍♂️

Piotr Wrzosek @pewu78.bsky.social · Jul 1

ORA-600/ORA-7445 Troubleshooting tools on MOS are not working for me - at least since yesterday.

1 2

Reposted by Timur Akhmadeev

The Register @theregister.com · 8d

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

2 6

Timur Akhmadeev @tmmdv.bsky.social · 19d

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.

4 1 3

Timur Akhmadeev @tmmdv.bsky.social · 20d

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

3 2

Timur Akhmadeev @tmmdv.bsky.social · 25d

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

4

Timur Akhmadeev @tmmdv.bsky.social · 29d

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

www.amazon.es

1

Reposted by Timur Akhmadeev

Ilmar Kerm @ilmarkerm.eu · Sep 8

Oracle Core: Essential Internals for vibe coders

1 1 6

Reposted by Timur Akhmadeev

Priit Piipuu @ppiipuu.bsky.social · Sep 6

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

1 5 26

Timur Akhmadeev @tmmdv.bsky.social · Sep 6

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

1 5

Reposted by Timur Akhmadeev

Dani Schnider @danischnider.bsky.social · Sep 6

Premiere at #POUG2025: @jloracle.bsky.social shows pictures on his slides 😁

2 6

Reposted by Timur Akhmadeev

Martin Berger (berx) @martinberx.bsky.social · Sep 6

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

1 7

Reposted by Timur Akhmadeev

Priit Piipuu @ppiipuu.bsky.social · Sep 5

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

3 5

Reposted by Timur Akhmadeev

Erik van Roon @evrocs.bsky.social · Sep 5

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!

5 11

Timur Akhmadeev @tmmdv.bsky.social · Sep 5

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

2 6

Timur Akhmadeev @tmmdv.bsky.social · Sep 5

So it begins! @pougorg.bsky.social

4

Timur Akhmadeev @tmmdv.bsky.social · Sep 3

Is there better news?
No.

Radiohead @radiohead.wastehq.social · Sep 3

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.

Timur Akhmadeev @tmmdv.bsky.social · Sep 3

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)

1

Timur Akhmadeev @tmmdv.bsky.social · Sep 3

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

Monika Lewandowska @monikalewandowska.bsky.social · Sep 2

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

1 1

Timur Akhmadeev @tmmdv.bsky.social · Aug 29

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

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.

zerogpt.com

2 1

Timur Akhmadeev @tmmdv.bsky.social · Aug 29

You can do an online “director’s cut” 6h version later. No pressure though.

2

Timur Akhmadeev @tmmdv.bsky.social · Aug 29

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

1 1

Reposted by Timur Akhmadeev

Jonathan Lewis @jloracle.bsky.social · Aug 28

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

1 2