create objects inmemory options
inmemory只存列資料
inmemory option中可以建立表指定,也可以建立表空間指定。
看建立語句
http://docs.oracle.com/database/121/SQLRF/statements_7003.htm#i2231734
點選( 此處 )摺疊或開啟
-
SQL > create tablespace test datafile '/u01/app/oracle/oradata/prod/test01.dbf' size 200M default inmemory ;
-
-
Tablespace created .
-
-
SQL > create user c## test identified by tiger default tablespace test ;
-
-
User created .
-
-
SQL > alter user c## test account unlock ;
-
-
User altered .
-
-
SQL > grant connect , resource to c## test ;
-
-
Grant succeeded .
-
-
SQL > alter user c## test quota unlimited on test ;
-
-
User altered .
點選( 此處 )摺疊或開啟
-
CREATE TABLE dept ( deptno NUMBER ( 2 ) , dname VARCHAR2 ( 14 ) , loc VARCHAR2 ( 13 ) ) ;
-
INSERT INTO dept VALUES ( 10 , 'ACCOUNTING' , 'NEW YORK' ) ;
-
INSERT INTO dept VALUES ( 20 , 'RESEARCH' , 'DALLAS' ) ;
-
INSERT INTO dept VALUES ( 30 , 'SALES' , 'CHICAGO' ) ;
-
INSERT INTO dept VALUES ( 40 , 'OPERATIONS' , 'BOSTON' ) ;
-
CREATE TABLE emp ( empno NUMBER ( 4 ) , ename VARCHAR2 ( 10 ) , job VARCHAR2 ( 9 ) , mgr NUMBER ( 4 ) , hiredate DATE , sal NUMBER ( 7 , 2 ) , comm NUMBER ( 7 , 2 ) , deptno NUMBER ( 2 ) ) ;
-
INSERT INTO emp VALUES ( 7369 , 'SMITH' , 'CLERK' , 7902 , SYSDATE , 800 , null , 20 ) ;
-
INSERT INTO emp VALUES ( 7499 , 'ALLEN' , 'SALESMAN' , 7698 , SYSDATE , 1600 , 300 , 30 ) ;
-
INSERT INTO emp VALUES ( 7521 , 'WARD' , 'SALESMAN' , 7698 , SYSDATE , 1250 , 500 , 30 ) ;
-
INSERT INTO emp VALUES ( 7566 , 'JONES' , 'MANAGER' , 7839 , SYSDATE , 2975 , null , 20 ) ;
-
INSERT INTO emp VALUES ( 7654 , 'MARTIN' , 'SALESMAN' , 7698 , SYSDATE , 1250 , 1400 , 30 ) ;
-
INSERT INTO emp VALUES ( 7698 , 'BLAKE' , 'MANAGER' , 7839 , SYSDATE , 2850 , null , 30 ) ;
-
INSERT INTO emp VALUES ( 7782 , 'CLARK' , 'MANAGER' , 7839 , SYSDATE , 2450 , null , 10 ) ;
-
INSERT INTO emp VALUES ( 7788 , 'SCOTT' , 'ANALYST' , 7566 , SYSDATE , 3000 , null , 20 ) ;
-
INSERT INTO emp VALUES ( 7839 , 'KING' , 'PRESIDENT' , NULL , SYSDATE , 5000 , null , 10 ) ;
-
INSERT INTO emp VALUES ( 7844 , 'TURNER' , 'SALESMAN' , 7698 , SYSDATE , 1500 , , 30 ) ;
-
INSERT INTO emp VALUES ( 7876 , 'ADAMS' , 'CLERK' , 7788 , SYSDATE , 1100 , null , 20 ) ;
-
INSERT INTO emp VALUES ( 7900 , 'JAMES' , 'CLERK' , 7698 , SYSDATE , 950 , null , 30 ) ;
-
INSERT INTO emp VALUES ( 7902 , 'FORD' , 'ANALYST' , 7566 , SYSDATE , 3000 , null , 20 ) ;
-
INSERT INTO emp VALUES ( 7934 , 'MILLER' , 'CLERK' , 7782 , SYSDATE , 1300 , null , 10 )
select
e.ename
,
e.job
,
d.dname
from
emp e
,
dept d
where
e.deptno
=
d.deptno
and
e.sal
<
2000
;
create index ind on emp(empno);後還是走如上的執行計劃。
如下是我執行>的某個語句產生的執行計劃,或許是表的關聯方式和以前沒有什麼區別,但是表的訪問路徑真的就是走inmemory了,後續還待驗證。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29990276/viewspace-1816530/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Create CLR objects CS.sqlObjectSQL
- inmemory OOM了OOM
- Oracle 12c啟用inmemory特性Oracle
- Flutter Analysis OptionsFlutter
- flush 快取對inmemory有什麼影響?快取
- 【檢視】oracle 資料字典檢視之 DBA_OBJECTS / ALL_OBJECTS / USER_OBJECTS(OBJ)OracleObject
- 一次inmemory丟失引起的問題分析
- Oracle dba_objects和all_objects 最大的區別OracleObject
- 淺談Associated ObjectsObject
- Destroying Window ObjectsObject
- Naming Database ObjectsDatabaseObject
- JavaScript select options 集合JavaScript
- Setup – Profile Options – OA FrameworkFramework
- [轉]Golang Functional Options PatternGolangFunction
- Net6 Configuration & Options 原始碼分析 Part2 Options原始碼
- zend_objects_store_putObject
- Objects as Points 論文總結Object
- PDO--PHP Data ObjectsPHPObject
- row cache objects latch研究Object
- Cost objects in SAP R/3Object
- Program Units and Referenced Objects (244)Object
- idea VM Options 設定Idea
- python http OPTIONS請求PythonHTTP
- Struts中html:options的使用HTML
- 2.3.2 Application Common ObjectsAPPObject
- 2.1.3.3 Container Data Objects in a CDBAIObject
- Latch: Row Cache Objects (One bug?)Object
- Business Objects Query Builder – Part IIObjectUI
- Convert Array of Objects to Data TableObject
- Accessing Frequently Used Dictionary ObjectsObject
- Introduction to Schema Objects (153)Object
- Performance and High-Availability OptionsORMAI
- filesystemio_options設定說明
- nginx設定X-Frame-OptionsNginx
- Create DatabaseDatabase
- create index/create index online區別Index
- 2.2.5 Overview of Common and Local Objects in a CDBViewObject
- 好用的java.util.Objects類JavaObject