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 Oracle Developers Oracle User Groups Oracle Database

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

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 Oracle ACE Program

Just in case if you missed my night tweet:

CBO and Partial indexes: orasql.org/2022/11/02/cbo… #oracle #sql #partial_indexes Oracle ACE Program

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

Use "me" instead 🤣

#31 🤣

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

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

Two awesome geeky Oracle researching blog posts by Mikhail Velikikh * mvelikikh.blogspot.com/2023/04/x-tabl… * mvelikikh.blogspot.com/2023/04/xmessa…

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

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

Does anybody know how to make Home/End buttons work in Oracle SQL Developer on Macbook m2? SQL.ProductManager.Oracle.Databases krisrice 🏒🍺📷 ? PS. Don't know why ~/Library/KeyBindings doesn't work for Slack and Oracle SQL Developer ¯\_(ツ)_/¯

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 Fedor Shabashev Thanks to @RevolutApp for hosting.

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

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…

Partitioning by node (instance_number): orasql.org/2024/12/12/par… #oracle #gc #rac

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

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/par… #Oracle #SQL #OracleDatabase #Performance #SQLMonitor #RTSM #PLSQL