I'm Nigel Bayliss. I work for Oracle. The opinions expressed here are my own. I'm the Oracle Optimizer PM and my background is doing stuff with very large DBs.
@HSBC_UK is your credit eligibility check website working properly? https://t.co/Os2a0acVfX - Soft searches appear in my Clearscore account but your site says it is unable to confirm my identity (many times now). If I use Experian's eligibility check site, it works fine.
At DOAG I was asked an interesting question about real-time SPM and runaway/terminated SQL.
I didn't know the answer for sure, but I do now. Scroll to the bottom of https://t.co/MwxKPmSpWN for a new ADB demo.
The tool I used to render explain plan trees for the #DOAG2018 session is a Java utility I wrote a while back in an attempt to make execution plan presentations slightly more visually appealing - oplantree - https://t.co/bGUMEwo9zk
@oradiag@TanelPoder@JLOracle@NenadNoveljic If you look at the definition of DBA_IND_STATISTICS (using DBA_INDEXES, for example), you will see how index staleness is derived. Maybe the 'ANALYZETIME' comparison is the clue you need.
@tmmdv If you're interested, try a similar example with PX. I suspect you will get different behaviour, but I have not tested it myself. Needs to be at least 21c, so I would try 23ai.
@tmmdv The existing ER covers it. I think a proper fix requires more than a patch, and Base is definitely aware already. An SR doesn't seem the right way to me, but it's ultimately your call.