Re: Oracle 12c Inmemory - don't stop thinking
From: Hans Forbrich <fuzzy.graybeard_at_gmail.com>
Date: Mon, 28 Jul 2014 12:03:16 -0600
Message-ID: <53D69064.5000508_at_gmail.com>
On 28/07/2014 11:02 AM, Kevin Jernigan wrote:
> In 12.1.0.2, inmemory_size is set to 0 by default, and unless it has a
> non-zero value, usage of the Database In-Memory option will track as
> "false". Note that the DBA has to go out of his/her way to set
> inmemory_size, as you must restart the db instance for changes to
> non-zero values to take effect.
>
> So, it is explicitly NOT TRUE that Database In-Memory is enabled by
> default - and it's (IMHO) irresponsible (at best) to suggest otherwise...
>
> -KJ
Date: Mon, 28 Jul 2014 12:03:16 -0600
Message-ID: <53D69064.5000508_at_gmail.com>
On 28/07/2014 11:02 AM, Kevin Jernigan wrote:
> In 12.1.0.2, inmemory_size is set to 0 by default, and unless it has a
> non-zero value, usage of the Database In-Memory option will track as
> "false". Note that the DBA has to go out of his/her way to set
> inmemory_size, as you must restart the db instance for changes to
> non-zero values to take effect.
>
> So, it is explicitly NOT TRUE that Database In-Memory is enabled by
> default - and it's (IMHO) irresponsible (at best) to suggest otherwise...
>
> -KJ
Thanks for the verification - that information is indeed buried in the latest rev of the Admin manual.
That said, it would be nice for Oracle to adopt a method to consistently turn off options so they can not be inadvertently turned on.
Something like "OPTION_{optionName} = 'ON | OFF | DISABLED | ALWAYS DISABLED' " /Hans
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jul 28 2014 - 20:03:16 CEST