dbms_xtender's profile picture. Oracle performance tuning engineer, Oracle DEVVY winner, Oracle ACE Pro ♠
http://orasql.org

Sayan Malakshinov

@dbms_xtender

Oracle performance tuning engineer, Oracle DEVVY winner, Oracle ACE Pro ♠ http://orasql.org

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/int… #Oracle #SQL #DatabaseOptimization #IntervalSearch


Sayan Malakshinov 님이 재게시함

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/2024/03/20/ind…

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/2024/03/15/ind…



Sayan Malakshinov 님이 재게시함

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


Sayan Malakshinov 님이 재게시함

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… Orgs: me and @FedorShabashev Thanks to @RevolutApp for hosting.


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 ¯\_(ツ)_/¯


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


Oracle diagnostic events — Cheat sheet Update 3: how to catch and trace ‘alter table’ operation? orasql.org/2021/05/20/ora…


Sayan Malakshinov 님이 재게시함

Ok, I like #chatGPT 🤣 How much does Sayan Malakshinov know about #oracle database: PS. @oracleace, #chatGPT says I'm an Oracle ACE Director 😉

dbms_xtender's tweet image. Ok, I like #chatGPT 🤣 How much does Sayan Malakshinov know about #oracle database: 

PS. @oracleace,  #chatGPT says I'm an Oracle ACE Director 😉

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


#31 🤣

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/2024/03/15/ind…



Use "me" instead 🤣

Please 🙏

SwexyDev's tweet image. Please 🙏


Was asked about "bad performance". Checked awr: 🤣#oracle #performance #troubleshooting #Oracleperformance

dbms_xtender's tweet image. Was asked about "bad performance". Checked awr:
 🤣#oracle #performance #troubleshooting #Oracleperformance

Just in case if you missed my night tweet:

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/slo… #sql #nulls #oracle @oracleace



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/slo… #sql #nulls #oracle @oracleace


Optimizing #IRS (index range scan) for ":X between A and B" gist.github.com/xtender/63acc0…

dbms_xtender's tweet image. Optimizing #IRS (index range scan) for ":X between A and B"
gist.github.com/xtender/63acc0…

Sayan Malakshinov 님이 재게시함

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

oracleace's tweet image. 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

Loading...

Something went wrong.


Something went wrong.