Hybrid columnar compression (HCC) changes the way row data is stored to obtain dramatically better compression ratios, often 10x or more. Rather than storing a series of rows inside a data block, HCC operates on an aggregate group of data blocks called a compression unit. Within the compression unit, HCC-compressed data contains the data for […]
Read More
The Exadata flash cache makes use of flash memory to speed up access to commonly used data. Flash-based solid-state storage has latency times and I/O operation rates much higher than rotating storage, improving performance particularly in transaction-processing applications. The flash cache is stored on flash-memory cards on storage servers. The storage server software manages the […]
Read More
Storage indexes build on the smart scan functionality by dividing the physical table data into storage regions and tracking the highest and lowest values for each storage region. When a SELECT query is run on the table, the smart scan code can compare the saved high and low values with the where clause from the […]
Read More
Storage offload is a key performance optimization found only in Exadata. The Exadata storage server software understands Oracle database file layouts, so you can use smart scans to perform part of the work database servers normally do. By doing data processing closer to the storage, Exadata storage servers reduce the amount of data transferred to […]
Read More
To understand Exadata’s performance, it’s helpful to look at traditional enterprise storage. Traditional storage is dominated by large storage area networks (SANs) and network attached storage (NAS) devices. These storage architectures help to share and manage storage among multiple client devices, but their main building blocks are large banks of rotating hard drives and solid-state […]
Read More
Get a quick overview of the Oracle Exadata Storage Expansion Rack added in July, 2011, especially useful for storing petabytes of information.
Read More
Oracle hybrid columnar compression can make operations faster because the query runs without decompression. Learn why.
Read More
Oracle has two very important parameters to use to test major features of Exadata: CELL_OFFLOAD_PROCESSING and _KCFIS_STORAGEIDX_DISABLED. Learn more.
Read More
Learn best practices for getting the most from Oracle Exadata for your Oracle 11gR2 database instances.
Read More
Oracle Exadata hardware combines the power of the database with features Oracle added at the hardware level that other hardware providers can’t replicate easily. Learn more.
Read More