Sayan Malakshinov

Oracle performance tuning engineer, Oracle DEVVY winner, Oracle ACE Pro ♠

[Sayan Malakshinov @dbms_xtender]

New post: Parsing Oracle RTSM (Real-Time SQL Monitor) XML reports using SQL Macros in 19c.
Updated PKG_RTSM now exposes report info, plan details, plan ops & Activity% via pure SQL.
👉 https://t.co/1ciEsuXTAy

#Oracle #SQL #OracleDatabase #Performance #SQLMonitor #RTSM #PLSQL

[Sayan Malakshinov @dbms_xtender]

@MaximDemenko Hi Maxim, thanks! I tried spatial indexes for that ~10yrs ago. IIRC, I even shared the results, but I can’t find them now. In short, the performance was very ineffective. Additionally, even using object types for DRS (which was my initial approach) noticeably slowed things down

[Sayan Malakshinov @dbms_xtender]

I finally wrote about my method for optimizing interval search—something I promised a long time ago! It ended up being quite lengthy, so I turned it into a series:
👉 https://t.co/Ay9jmvrcS0
#Oracle #SQL #DatabaseOptimization #IntervalSearch

[Sayan Malakshinov @dbms_xtender]

@ToonKoppelaars Ah, ok, of course, will do, thanks! Didn't know about that

[Sayan Malakshinov @dbms_xtender]

Partitioning by node (instance_number):
https://t.co/bDacyXiACt
#oracle #gc #rac

[Jonathan Lewis @JLOracle]

Just published part 2 of my mini-series on index usage tracking just posted. It may receive some updates over the next few days if questions appear in the comments:
https://t.co/3fGbEtrZlB

[Sayan Malakshinov @dbms_xtender]

@FranckPachot Just use an external table :)

[Sayan Malakshinov @dbms_xtender]

@TanelPoder The optimizer sighs: why did you add this meaningless join with a parent table? Why did you list 5 columns in your subquery, if you fetch just 2 of them? What did you mean writing this query?
....
Here is what you *need*, not what did you mean...

[that Jeff Smith @thatjeffsmith]

If you're doing these things, please stop, or maybe consider a career change:

1) posting the same question in multiple internal Slack/Teams/Whatever spaces

2) saying "it does not work," with no details

3) sharing pictures of code

4) preceding 1-3 with 'Hi' and nothing else

[Alexandr Notchenko @Gang1man]

16th London Pytorch Meetup will take place Next Thursday (October 5). 3 speakers covering deep technical topics: RLHF, Diffusion models, differentiable physical simulation.
Register now https://t.co/Xd81RpgMxq

Orgs: me and @FedorShabashev
Thanks to @RevolutApp for hosting.

[Sayan Malakshinov @dbms_xtender]

@tmmdv Nice drawings! 👍Much better than I can! 😁

[Sayan Malakshinov @dbms_xtender]

@krisrice @OracleSQLDev @code Oh, it would be great also to have an ability to specify datatypes for bind variables into the bind variables popup window, and date/timestamp variables for VAR command (unfortunately, nor sqlplus, nor sqlcl/sql developer still do not support them) 🙏

[Sayan Malakshinov @dbms_xtender]

@krisrice @OracleSQLDev @thatjeffsmith Ah, sorry, I meant that I have a MS ergonomic keyboard with Home/End/etc connected through KVM switch. Anyway my colleagues found a working solution: https://t.co/V5CBkfHoRt + https://t.co/graybHbEFE

[Sayan Malakshinov @dbms_xtender]

Does anybody know how to make Home/End buttons work in @OracleSQLDev on Macbook m2?
@thatjeffsmith @krisrice ?

PS. Don't know why ~/Library/KeyBindings doesn't work for Slack and Oracle SQL Developer
¯\_(ツ)_/¯

[Sayan Malakshinov @dbms_xtender]

#StrangeFridayThoughts: no_query_transformation can help developers to write better and faster queries (?)

[Sayan Malakshinov @dbms_xtender]

@ora600pl @Oracle_Edu Btw, Oracle splits columns into row pieces in reverse order, and though it does not store trailing NULLs in a row, this is not the case for a row piece: https://t.co/D4U7xSJeWC

[Sayan Malakshinov @dbms_xtender]

@Mautro @OracleSK I mean that the 'outline' section is the best for such things :)

[Sayan Malakshinov @dbms_xtender]

@Mautro @OracleSK That's why always ask to provide execution plans with format =>'advanced' 🤣

[Sayan Malakshinov @dbms_xtender]

@tmmdv @JBeresniewicz @jer_s Database performance is now such a complex issue... It's like the 'performance' of the human body - one metric isn't enough, the more we have, the more complete the picture (cardiogram, breathing, blood pressure/analysis, etc.). Similarly, AAS is one of those crucial metrics.