Databases Reference
In-Depth Information
Table 2-1.
Exadata Storage Server software at a glance
Software Feature
What It Does
How It's Used
Workload Impact
Reference
Smart Scan
Offloads I/O operations to storage
servers
Used automatically for qualified
SQL statements
Can dramatically improve
performance for full-scan
operations
Chapter 15
Hybrid Columnar
Compression
Compresses tables
As administrator creates HCC table
Saves disk space and potentially
I/O
Chapter 16
Smart Flash Cache
Provides 384 GB of PCI flash per
storage cell on X2 and 1.6 TB of PCI
flash on the X3 to reduce I/O latency
Implemented automatically and
intelligently; only “smart” enabled
operations and blocks are cached
Can provide performance
improvements for OLTP
applications and other workloads
Chapter 18
Smart Flash
Logging
Utilizes a small chunk of PCI flash to
cushion redo log writes
Used automatically when redo log
writes to disk cache are saturated
Provides PCI flash- write speeds
in the event disk cache is
saturated, reducing likelihood for
LGWR to become bottleneck
Chapter 18
Storage Indexes
Enables I/O requests to bypass
storage regions on the Exadata cell,
allowing queries to run faster
Storage server maintains high- and
low-column values for predicate
conditions enabling I/Os to be skipped
Can provide dramatic performance
gains if data is well-sorted with
respect to predicate conditions
Chapter 19
I/O Resource
Management
Provides mechanism to prioritize and
meter I/O to Exadata disk resources
by database, consumer group, or
category
IORM plans defined by
administrator according to
performance SLAs per database,
category, or consumer group
Can enable I/O performance
investment protection in
consolidated environment
Chapter 17
Search WWH ::
Custom Search