欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

oracle12cR2inmemory

程序员文章站 2022-06-24 19:53:17
oracle12cR2inmemory,查看参数设置 SQL> show parameter inmemory NAME...

oracle12cR2inmemory,查看参数设置

SQL> show parameter inmemory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
inmemory_adg_enabled                   boolean     TRUE
inmemory_clause_default                string
inmemory_expressions_usage         string      ENABLE
inmemory_force                                  string      DEFAULT
inmemory_max_populate_servers        integer     0
inmemory_query                                      string      ENABLE
inmemory_size                                           big integer 0
inmemory_trickle_repopulate_servers_ integer     1
percent
inmemory_virtual_columns             string      MANUAL
optimizer_inmemory_aware             boolean     TRUE

参数inmemory_size,指定可以作为内存列存的内存

SQL> alter system set inmemory_size=800M cope=spfile;

inmemory_max_populate_servers 用于将数据加载到内存的后台进程数量

SQL> alter system set inmemory_max_populate_servers=2;

SQL> show sga

Total System Global Area 1543503872 bytes
Fixed Size                  8793112 bytes
Variable Size             570426344 bytes
Database Buffers          117440512 bytes
Redo Buffers                7983104 bytes
In-Memory Area            838860800 bytes

验证:

SQL> select * from zxq;

72633 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 3272699641

--------------------------------------------------------------------------
| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |
--------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |      | 72633 |  9433K|   396   (1)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| ZXQ  | 72633 |  9433K|   396   (1)| 00:00:01 |
--------------------------------------------------------------------------


Statistics
----------------------------------------------------------
          0  recursive calls
          5  db block gets
       6176  consistent gets
          0  physical reads
          0  redo size
   11079730  bytes sent via SQL*Net to client
      53869  bytes received via SQL*Net from client
       4844  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      72633  rows processed

内存话处理:

SQL> alter table zxq inmemory;

Table altered.

SQL>  select * from zxq;

72633 rows selected.


Execution Plan
----------------------------------------------------------
Plan hash value: 3272699641

-----------------------------------------------------------------------------------
| Id  | Operation                  | Name | Rows  | Bytes | Cost (%CPU)| Time     |
-----------------------------------------------------------------------------------
|   0 | SELECT STATEMENT           |      | 72633 |  9433K|    21  (29)| 00:00:01 |
|   1 |  TABLE ACCESS INMEMORY FULL| ZXQ  | 72633 |  9433K|    21  (29)| 00:00:01 |
-----------------------------------------------------------------------------------


Statistics
----------------------------------------------------------
          0  recursive calls
          3  db block gets
          9  consistent gets
          0  physical reads
          0  redo size
    4836448  bytes sent via SQL*Net to client
      53869  bytes received via SQL*Net from client
       4844  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
      72633  rows processed

查看内存区域的使用情况

SQL> select * from V$INMEMORY_AREA;

POOL                       ALLOC_BYTES USED_BYTES POPULATE_STATUS                CON_ID
-------------------------- ----------- ---------- -------------------------- ----------
1MB POOL                     670040064    4194304 DONE                                5
64KB POOL                    150994944     262144 DONE                                5