Unlocking Performance with Oracle 23AI’s True Cache

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”

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”