Re: Question on IO consideration

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: Ghassan Salem <salem.ghassan@xxxxxxxxx>
  • Date: Wed, 22 Sep 2021 17:40:07 -0400

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


--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Other related posts: