Summer season is almost over. And in between Oracle AI World in Las Vegas in October and now, there is one chance to meet us for a Full Day Upgrade / Migration / Patching Workshop in Prague on Sept…| Upgrade your Database - NOW!
This time the AutoUpgrade team did magic and included so many great new features and useful enhancements into the new version of AutoUpgrade. So, please note: The August 2025 version of AutoUpgrade (25.4) is available for download. You should refresh your current versions, especially when you use it for patching, and especially if you attempt to do in an RAC (Real Application Clusters) environment. But read more below. Photo by Possessed Photography on Unsplash How to download it? As usual,...| Upgrade your Database – NOW!
I am jealous, and so happy. There are so happy about the fact that we have such skilled minds in the industry. One of them is Marcus Vinicius, an Oracle ACE Pro from Brazil who lives in Dallas, TX …| Upgrade your Database - NOW!
Many of you know it and downloaded it already. But just in case you are not aware yet, let me give you a quick summary since the May 2025 version of AutoUpgrade (25.3) is available for download. Photo by julien Tromeur on Unsplash How to download it? That’s very simple. You either download it via the well-known MOS Note: 2485457.1 – AutoUpgrade Tool or you fetch it directly from oracle.com with curl, wget or by just clicking on the big buttom. What’s new? Well, 25.3 is a one-fix-only...| Upgrade your Database – NOW!
I know, not everybody is a huge fan of new features in RUs. But how do find new features in Oracle Release Updates (RUs)? Are the listed anywhere? They are, no worries. At least since Oracle Database 19c. Photo by Jake Weirick on Unsplash New Features in RUs? I can already sense that some of you will be tempted to comment and tell me that you don’t like any new features in Oracle Database Release Updates, in short: RUs. But on the other hand there is also something good with it. Rather than...| Upgrade your Database – NOW!
Oracle's heuristics previously avoided considering fixed tables for Join Predicate Pushdown (JPPD) transformation, leading to suboptimal plans. Enforcing predicate pushing into the view with the PUSH_PRED hint was a workaround. Oracle addressed this in the 21c release, evaluating fixed tables for JPPD. Continue Reading → The post Performance Improvement on Dictionary Views in Oracle 21c appeared first on All-round Database Topics.| All-round Database Topics
