Re: Oracle 12c Inmemory - don't stop thinking

http://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN14239

*To enable the IM column store, the INMEMORY_SIZE initialization parameter must be set to a non-zero value.*

Seth Miller

On Mon, Jul 28, 2014 at 1:03 PM, Hans Forbrich <fuzzy.graybeard_at_gmail.com> wrote:

> 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-l