December 2017 M T W T F S S « Nov 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Comonly used Tags12c Audio Autonomous beginners Big Data birthday cursor_sharing Database DBA DBMS_XPLAN Docker events Exadata Execution Plans Github Hints histograms In-Memory IoT JSON Multitenant My_Activities OOW optimizer Oracle Oracle Database 12c Partitioning Performance REST Security Sharding SQL Monitor statistics syntax top_tip UKOUG Usergroup video
- AskTom (5)
- Autonomous Database (1)
- Beginners (1)
- Database In-Memory (4)
- Docker (2)
- Events (9)
- Exadata (1)
- IoT (1)
- Multitenant (2)
- New Features (3)
- OOW (8)
- Optimizer (9)
- Oracle Database 12c New Features (16)
- Partititoning (1)
- Sharding (1)
- Statistics (1)
- Syntax (4)
- technical_papers (2)
- Uncategorized (1)
- Whitepapers (1)
Tag Archives: In-Memory
Last week I spent some time beta testing Oracle Database 12c RAC on docker (more on this in a future post) and decided to take a trip down memory lane and play around with Oracle Database In-Memory. One of the … Continue reading
My favorite marquee feature in Oracle Database 12c is Database In-Memory. With the introduction of Database In-Memory in 22.214.171.124, data can now be populated into memory both in a row format (the buffer cache) and a new in-memory optimized column … Continue reading
Today Oracle Database 12c Release 2 became available for download on Oracle.com for both Linux & SPARC. So anyone who wasn’t ready to try 12.2 in the Cloud can now play around with it, in the comfort of their own environment.
With each new release of the Oracle Database come fundamental architectural changes, driven by new technologies and user requirements. This has never been more evident than with Oracle Database 12c, which has 3 marquee features: Continue reading
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