本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger 的Oracle技术博客 本文链接地址: Oracle 12c New FeaturesIn Memory Option(1) Oracle 12.1.0.2版本了引入了一个非常牛叉的功能，即In Memory option，这是十分具有诱惑力的，针对
本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: Oracle 12c New Features—In Memory Option(1)
Oracle 12.1.0.2版本了引入了一个非常牛叉的功能，即In Memory option，这是十分具有诱惑力的，针对这个重大的变化，我会进行一个系列文章的分析，这是第一篇。
首先，我们来尝试下In Memory option功能。
[oracle@ora12012 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 12.1.0.2.0 Beta on Tue Jul 29 05:30:26 2014Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit BetaWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing optionsSQL>SQL>SQL>SQL> select open_mode from v$database;OPEN_MODE--------------------READ WRITESQL> select * from v$option where PARAMETER like '%In-Memory%';PARAMETER VALUE CON_ID-------------------------------- ------------------- ----------In-Memory Column Store TRUE 0In-Memory Aggregation TRUE 0SQL> select name,open_mode from v$pdbs;NAME OPEN_MODE------------------------------ ----------PDB$SEED READ ONLYPDBORCL READ WRITEKILLDB READ WRITESQL> conn roger/[email protected]> create table t_memory as select * from dba_objects;Table created.SQL> select owner,table_name,INMEMORY,INMEMORY_DISTRIBUTE from dba_tables where table_name='T_MEMORY';OWNER TABLE_NAME INMEMORY INMEMORY_DISTRI---------- ------------------------------ -------- ---------------ROGER T_MEMORY DISABLEDSQL> set autot onSQL> select count(1) from T_MEMORY;COUNT(1)---------- 90922Execution Plan----------------------------------------------------------Plan hash value: 620019089-----------------------------------------------------------------------| Id | Operation | Name | Rows | Cost (%CPU)| Time |-----------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 416 (1)| 00:00:01 || 1 | SORT AGGREGATE | | 1 | | || 2 | TABLE ACCESS FULL| T_MEMORY | 90922 | 416 (1)| 00:00:01 |-----------------------------------------------------------------------Statistics---------------------------------------------------------- 2 recursive calls 0 db block gets 1529 consistent gets 1525 physical reads 0 redo size 544 bytes sent via SQL*Net to client 551 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 1 rows processedSQL> select count(1) from T_MEMORY;COUNT(1)---------- 90922Execution Plan----------------------------------------------------------Plan hash value: 620019089-----------------------------------------------------------------------| Id | Operation | Name | Rows | Cost (%CPU)| Time |-----------------------------------------------------------------------| 0 | SELECT STATEMENT | | 1 | 416 (1)| 00:00:0<div>本文来源gaodai.ma#com搞#代!码网_</div>1 || 1 | SORT AGGREGATE | | 1 | | || 2 | TABLE ACCESS FULL| T_MEMORY | 90922 | 416 (1)| 00:00:01 |-----------------------------------------------------------------------Statistics---------------------------------------------------------- 36 recursive calls 0 db block gets 1575 consistent gets 1525 physical reads 0 redo size 544 bytes sent via SQL*Net to client 551 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 5 sorts (memory) 0 sorts (disk) 1 rows processed
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：Oracle 12c New Features—In Memory Option(1)
转载请注明原文链接：Oracle 12c New Features—In Memory Option(1)
