Oracle 23AI introduces a groundbreaking feature called True Cache, which provides an in-memory caching layer for frequently accessed data. This significantly improves read performance, especially in environments where quick access to repetitive data queries is critical. However, don’t confuse it with the “In-Memory” feature, as both serve very different use cases. Let’s explore the details.Continue reading “Unlocking Performance with Oracle 23AI’s True Cache”
Category Archives: Non classé
Benefits of Zstandard Compression in Oracle 23ai HCC
In Oracle Database 23ai, significant improvements have been made to Hybrid Columnar Compression (HCC), with the default compression method now utilizing Zstandard (Zstd) instead of the previous algorithms, zlib and bzip2. But what exactly is Zstandard, and how does it differ from zlib and bzip2? Zstandard is a lossless data compression algorithm developed by YannContinue reading “Benefits of Zstandard Compression in Oracle 23ai HCC”
How to patch Exadata PDU
Recently, I collaborated with a colleague to promote our Exadata system to a new Oracle Enterprise Manager (OEM) server. However, we encountered issues when attempting to promote the Power Distribution Unit (PDU). After consulting My Oracle Support (MOS), we decided to address potential bugs by applying the latest PDU patch before proceeding with the promotionContinue reading “How to patch Exadata PDU”
What should we do if the Flash Cache is degraded in an Exadata cell
Flash cache plays a critical role in Exadata performance. When issues arise, it’s crucial to understand the symptoms and resolution steps. Typically, each flash cache comprises four flash disks. If one flash disk fails, the cell service automatically removes it while continuing to operate with the remaining three disks. In most cases, immediate intervention isContinue reading “What should we do if the Flash Cache is degraded in an Exadata cell”
ZDLRA ERROR: Filesystem label ESP is found more than once.
Recently, while patching a ZDLRA X7-2 full stack to version 21.1.202405, I encountered an error during the dbnode precheck. This blog post details the issue and its resolution. The Error During the precheck, the following error was encountered: 2024-09-17 15:13:11 +0200 :ERROR : dbnodeupdate.sh precheck failed on one or more nodes SUMMARY OF WARNINGS ANDContinue reading “ZDLRA ERROR: Filesystem label ESP is found more than once.”
Oracle 19, recover standby become easier
Since oracle 19 , recover standby become quite easier. Here my dataguard configuration and it shows ORA-16810 error. DGMGRL> show configuration Configuration – ora19_cfg Protection Mode: MaxPerformance Members: ora19_pri – Primary database ora19_stb – Physical standby database Error: ORA-16810: multiple errors or warnings detected for the member Fast-Start Failover: Disabled Configuration Status: ERROR (status updatedContinue reading “Oracle 19, recover standby become easier”
Oracle DBA Insights 