Exadata Smart Flash Cache: Is a write-through cache, disk cache on exadata storage server.
It caches data for all instances that access the storage cell.
Caching:
Control file reads/writes are cached
File header reads/writes are cached
Data Blocks and Index blocks are cached
Skip Caching:
I/Os mirror copies, backups, data pump, tablespace formatting, resistant to tables scan are skipped.
Operation OFF-LOADBLE through smart scans include following:
1) Predicate filtering :
2) Column Projection:
3) Joins:
4) Data Mining Model scoring - For users of Oracle Data Mining, scroing functions like PREDICT() cab be evaluated on storage servers.
It caches data for all instances that access the storage cell.
Caching:
Control file reads/writes are cached
File header reads/writes are cached
Data Blocks and Index blocks are cached
Skip Caching:
I/Os mirror copies, backups, data pump, tablespace formatting, resistant to tables scan are skipped.
Operation OFF-LOADBLE through smart scans include following:
1) Predicate filtering :
2) Column Projection:
3) Joins:
4) Data Mining Model scoring - For users of Oracle Data Mining, scroing functions like PREDICT() cab be evaluated on storage servers.
No comments:
Post a Comment