Content-Type: multipart/alternative;
 boundary="------------INci509wqUYztY2odgwp1MKP"
Message-ID: <8dd2dcf0-85c6-a0c2-446d-654ac4ce4186@gmail.com>
Date: Wed, 22 Sep 2021 17:40:07 -0400
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:91.0) Gecko/20100101
 Thunderbird/91.1.0
Subject: Re: Question on IO consideration
Content-Language: en-US
To: Ghassan Salem <salem.ghassan@gmail.com>
Cc: oracle-l <oracle-l@freelists.org>
References: <CAKna9VaPUaB6SqaJwrvzkd9anaP0wPnTYzrN-sXacwPPGFX6YA@mail.gmail.com>
 <CAMHX9JL1vNEpS5ikHw_vaytBuYOrZ274gGpQDjnMm+fBiyK0Ng@mail.gmail.com>
 <89961f65-7365-75cb-f682-9060e055dd34@gmail.com>
 <CALEzESgd5GNbqvhK34LqbEZv2dsRzFT8Pwkq3GC6KgH6sJQ07w@mail.gmail.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
In-Reply-To: <CALEzESgd5GNbqvhK34LqbEZv2dsRzFT8Pwkq3GC6KgH6sJQ07w@mail.gmail.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com
--------------INci509wqUYztY2odgwp1MKP
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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@gmail.com> 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
>
>     --
>     http://www.freelists.org/webpage/oracle-l
>
>
-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--------------INci509wqUYztY2odgwp1MKP
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>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.<br>
    </p>
    <p>Regards<br>
    </p>
    <div class="moz-cite-prefix">On 9/22/21 03:51, Ghassan Salem wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CALEzESgd5GNbqvhK34LqbEZv2dsRzFT8Pwkq3GC6KgH6sJQ07w@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div>Mladen,</div>
        <div>The feature Tanel is mentioning is free, not to be confused
          with in-memory flashcache, which requires the inmemory option.</div>
        <div><br>
        </div>
        <div>Regards<br>
        </div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Wed, Sep 22, 2021 at 1:59
          AM Mladen Gogala &lt;<a href="mailto:gogala.mladen@gmail.com"
            moz-do-not-send="true" class="moz-txt-link-freetext">gogala.mladen@gmail.com</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>
          On 9/21/21 17:41, Tanel Poder wrote:<br>
          &gt; Exadata storage cells (starting from cellsrv v12.1.2.1.0
          / Jan 2015) <br>
          &gt; can use fully columnar flash cache for greatly speeding
          up reads (the <br>
          &gt; cache is fully columnar, not hybrid like the datafile
          storage).<br>
          <br>
          <br>
          And all they want in exchange for that capability is your
          first-born. <br>
          Bargain price, indeed. BTW, MariaDB can also do that, a bit
          cheaper.<br>
          <br>
          -- <br>
          Mladen Gogala<br>
          Database Consultant<br>
          Tel: (347) 321-1217<br>
          <a href="https://dbwhisperer.wordpress.com" rel="noreferrer"
            target="_blank" moz-do-not-send="true"
            class="moz-txt-link-freetext">https://dbwhisperer.wordpress.com</a><br>
          <br>
          --<br>
          <a href="http://www.freelists.org/webpage/oracle-l"
            rel="noreferrer" target="_blank" moz-do-not-send="true"
            class="moz-txt-link-freetext">http://www.freelists.org/webpage/oracle-l</a><br>
          <br>
          <br>
        </blockquote>
      </div>
    </blockquote>
    <pre class="moz-signature" cols="72">-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
<a class="moz-txt-link-freetext" href="https://dbwhisperer.wordpress.com">https://dbwhisperer.wordpress.com</a>
</pre>
  </body>
</html>
--------------INci509wqUYztY2odgwp1MKP--

--
http://www.freelists.org/webpage/oracle-l