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

Oracle told the press it was enabled by default. Here: 
Report: Oracle Patch Turns On $23,000 Upgrade - InformationWeek

  
             
Report: Oracle Patch Turns On $23,000 Upgrade - Informat...
Oracle is shipping its Database In-Memory feature with its latest patch, but the expensive option is reportedly turned on by default.  
View on web.archive.org Preview by Yahoo  
  

The big stink is unnecessary. We all know the difference between enabled and in use. For example, if RAC is linked in to the binary it is technically enabled. You have to implement settings and initiate DDL to take it from enabled to in-use. 

My example in the blog showed the same thing. I had to implement settings to go from enabled to in-use.

The fact that there is no way to totally disable is (ala chopt/make ins_rdbms.mk) should be the topic of conversation.






________________________________
 From: "Powell, Mark" <mark.powell2_at_hp.com>
To: ORACLE-L <oracle-l_at_freelists.org> 
Sent: Monday, July 28, 2014 10:15 AM
Subject: RE: Oracle 12c Inmemory - don't stop thinking
 

If the information is wrong on in-memory being automatically enabled then I apologize.  It probably is not worth the trouble to try to find the original Oracle posting where I found the information that it was enabled by default but it I do I will see about updating the information. 


-----Original Message-----
From: Kevin Jernigan [mailto:kevin.jernigan_at_oracle.com] 
Sent: Monday, July 28, 2014 1:03 PM
To: usn_at_usn-it.de; Powell, Mark
Cc: ORACLE-L
Subject: Re: Oracle 12c Inmemory - don't stop thinking

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

--
Kevin Jernigan
Senior Director Product Management
Advanced Compression, Hybrid Columnar
Compression (HCC), Database File System
(DBFS), SecureFiles, Database Smart Flash Cache, Total Recall, Database Resource Manager (DBRM), Direct NFS Client (dNFS), Continuous Query Notification (CQN), Index Organized Tables (IOT), Information Lifecycle Management (ILM)
+1-650-607-0392 (o)
+1-415-710-8828 (m)

On 7/28/14, 7:14 AM, Martin Klier wrote:
> Hi,
>
> "enabled by default" - is not exactly true. The INMEMORY pool is zero 
> by default, but I must confess I did not check how usage watermarks 
> for the option are checked.
>
> Regards
> Martin
>
>
> Am 25.07.2014 18:36, schrieb Powell, Mark:
>> I will add that this feature while enabled by default is extra-cost, very expensive extra-cost at that.
>>
>>
>> -----Original Message-----
>> Oracle tells us that InMemory will care for everything. But as usual, 
>> the BUT is well covered. In my recent blog post
>>
>> "Oracle 12c InMemory - don't stop thinking about performance"
>> http://www.usn-it.de/index.php/2014/07/25/oracle-12c-inmemory-dont-st
>> op-thinking-about-performance/--

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