Comonly used Tags
Tag Archives: Exadata
If you are on Exadata or taking advantage of Database In-Memory it’s possible your queries will benefit for the automatically created and maintained Storage Indexes.
But what exactly are Storage Indexes and why don’t I always see a benefit from them?
Let me start by describing what Storage Indexes are in relation to Database In-Memory but remember they behavior in exactly the same way on the Exadata storage cell.
A Storage Index keeps track of minimum and maximum values for each column in an In-Memory Compression Unit (IMCU) or 1MB chunk on the Exadata storage cells. When a query specifies a WHERE clause predicate, the In-Memory Storage Index on the referenced column(s) is examined to determine if any entries with the specified value exist. Continue reading
Earlier this week, Oracle officially released the newest edition in the Exadata family, the Exadata SL6. The SL6 is an Exadata where the x86 database servers have been replaced by SPARC Servers. It runs the same Exadata software and Oracle Linux as the x86 version and it has the identical interfaces and APIs, so an application or end-user won’t actually know the difference.
For me the real benefit of this solution is the chance to run Oracle Database 12c on the SPARC M7 processor.
What’s so great about the SPARC M7 chip? Continue reading