@dbms_xtender profile picture
Sayan Malakshinov @dbms_xtender
Joined December 2009
  • Tweets 1,982
  • Following 201
  • Followers 621
177 Photos and videos
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. 👉 orasql.org/2025/12/07/parsin… #Oracle #SQL #OracleDatabase #Performance #SQLMonitor #RTSM #PLSQL
63
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: 👉 orasql.org/2024/12/19/interv… #Oracle #SQL #DatabaseOptimization #IntervalSearch

1
1
3
226
Partitioning by node (instance_number): orasql.org/2024/12/12/partit… #oracle #gc #rac
1
2
148
Sayan Malakshinov retweeted
Jonathan Lewis@JLOracle
20 Mar 2024
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: jonathanlewis.wordpress.com/…

Index Usage – 2

In the first part of this series I introduced Index Usage Tracking and the view dba_index_usage – a feature that appeared in 12.2 as a replacement for index monitoring and the view dba_object…

jonathanlewis.wordpress.com
Jonathan Lewis@JLOracle
15 Mar 2024
How do I identify indexes that could be dropped - just started a short series about Index Usage Tracking that can you some decent insight into how effective your indexes are: jonathanlewis.wordpress.com/…
11
24
2,469
Sayan Malakshinov retweeted
that Jeff Smith
@thatjeffsmith
1 Feb 2024
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
7
7
36
3,591
Sayan Malakshinov retweeted
Alexandr Notchenko@Gang1man
26 Sep 2023
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 meetup.com/london-pytorch-me… Orgs: me and @FedorShabashev Thanks to @RevolutApp for hosting.

PyTorch Meetup #16, Thu, Oct 5, 2023, 7:00 PM | Meetup

Join us this October 5th for the London PyTorch Meetup #16. **About the Event**: PyTorch isn't just another framework; it's the de-facto standard for Deep Learning. Our co

meetup.com
1
8
14
2,760
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 ¯\_(ツ)_/¯
1
365
#StrangeFridayThoughts: no_query_transformation can help developers to write better and faster queries (?)
1
351
Oracle diagnostic events — Cheat sheet Update 3: how to catch and trace ‘alter table’ operation? orasql.org/2021/05/20/oracle…
6
19
1,628
Sayan Malakshinov retweeted
Stefan Koehler@OracleSK
15 Apr 2023
Two awesome geeky Oracle researching blog posts by @MVelikikh * mvelikikh.blogspot.com/2023/… * mvelikikh.blogspot.com/2023/…
5
8
1,935
Ok, I like #chatGPT 🤣 How much does Sayan Malakshinov know about #oracle database: PS. @oracleace, #chatGPT says I'm an Oracle ACE Director 😉
3
1
640
I wonder why dbms_adr/dbms_adr_app, and even dbms_system.ksdwrt, are not documented. It would be useful for developers to have access to them in rare, exceptional situations. #oracle #documentation #alertlog
1
1
368
#31 🤣
This tweet is unavailable
2
285
Use "me" instead 🤣
Sujeeth@SwexyDev
30 Dec 2022
Please 🙏
5
349
Was asked about "bad performance". Checked awr: 🤣#oracle #performance #troubleshooting #Oracleperformance
3
16
2,425
CBO and Partial indexes: orasql.org/2022/11/02/cbo-an… #oracle #sql #partial_indexes @oracleace

1
3
9
Just in case if you missed my night tweet:
Sayan Malakshinov@dbms_xtender
31 Oct 2022
Slow index access and COL=:N where :N is NULL: Another example when adding a redundant "dummy" predicate can fix problems: orasql.org/2022/10/31/slow-i… #sql #nulls #oracle @oracleace
3
Slow index access and COL=:N where :N is NULL: Another example when adding a redundant "dummy" predicate can fix problems: orasql.org/2022/10/31/slow-i… #sql #nulls #oracle @oracleace
2
11
Optimizing #IRS (index range scan) for ":X between A and B" gist.github.com/xtender/63ac…
3
10
Sayan Malakshinov retweeted
Oracle ACE Program
@oracleace
5 Oct 2022
Join us in congratulating the 2022 Oracle ACE Program Award Winners! 🎉 ♠️ 🥳 👏 Discover all of them in the latest article from the Oracle ACE blog 👉 social.ora.cl/6012Mdlx0 #OracleACE @OracleDevs @oracleugs @OracleDatabase
6
54
104
Load more