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