Re: in-memory option - worth it?

From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Thu, 15 Apr 2021 11:15:25 -0700
Message-ID: <CAKsxbLp9xCVC-yziCFFB9Vy6dM4rQ5dHby1C_Z-9tGWrWhP_SQ_at_mail.gmail.com>



Yep I am working through that right now. I just ran the advisor based on 16gb and reading through it. Looks like they show you the improvement if you had unlimited in-memory vs 16gb.

On Thu, Apr 15, 2021 at 9:29 AM Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> Hi Jeff,
>
> If you are on >=19.8, you can use new free base level of In-memory option
> up to 16GB:
> https://sqlmaria.com/2020/07/20/oracle-database-in-memory-base-level/
>
>
> On Thu, Apr 15, 2021 at 7:10 PM Jeff Chirco <backseatdba_at_gmail.com> wrote:
>
>> Hey curious if any have the In-Memory option and would it be worth it? We
>> are looking to increase our CPU footprint on our server and think about
>> maybe trying to squeeze this in if the discount is right. Although this is
>> the most expensive option. We are currently a small server, only 4cpu going
>> to 8, but we also have a DR server which would stay on a 4cpu server but I
>> know it also needs to be licensed.
>>
>> What time of systems is it best for? Any good blogs on it?
>>
>> Thanks,
>>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle performance tuning engineer
> Oracle ACE Associate
> http://orasql.org
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Apr 15 2021 - 20:15:25 CEST

Original text of this message