Yes, I know. Cache is columnar and it somewhat speeds things up.
However, to fully utilize columnar features, one needs In-Memory
option. And that's expensive.
Regards
On 9/22/21 03:51, Ghassan Salem wrote:
Mladen,--
The feature Tanel is mentioning is free, not to be confused with in-memory flashcache, which requires the inmemory option.
Regards
On Wed, Sep 22, 2021 at 1:59 AM Mladen Gogala <gogala.mladen@xxxxxxxxx> wrote:
On 9/21/21 17:41, Tanel Poder wrote:
> Exadata storage cells (starting from cellsrv v12.1.2.1.0 / Jan
2015)
> can use fully columnar flash cache for greatly speeding up reads
(the
> cache is fully columnar, not hybrid like the datafile storage).
And all they want in exchange for that capability is your first-born.
Bargain price, indeed. BTW, MariaDB can also do that, a bit cheaper.
-- Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--
//www.freelists.org/webpage/oracle-l