Oracle Version 19.3.0.0.0 On Windows Hyper-V Server 2019 Try In_Memory

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 6 08:31:43 2024
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> show parameter inmemory

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
inmemory_adg_enabled                 boolean     TRUE
inmemory_automatic_level             string      OFF
inmemory_clause_default              string
inmemory_expressions_usage           string      ENABLE
inmemory_force                       string      DEFAULT
inmemory_max_populate_servers        integer     0
inmemory_optimized_arithmetic        string      DISABLE
inmemory_prefer_xmem_memcompress     string
inmemory_prefer_xmem_priority        string
inmemory_query                       string      ENABLE
inmemory_size                        big integer 0

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
inmemory_trickle_repopulate_servers_ integer     1
percent
inmemory_virtual_columns             string      MANUAL
inmemory_xmem_size                   big integer 0
optimizer_inmemory_aware             boolean     TRUE
SQL> alter system set inmemory_size=1G;

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set inmemory_size=200M;

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02095: specified initialization parameter cannot be modified


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 5033163648 bytes
Fixed Size                  9038720 bytes
Variable Size            2248146944 bytes
Database Buffers         2768240640 bytes
Redo Buffers                7737344 bytes
Database mounted.
Database opened.



SQL> alter system set inmemory_size=200M scope=spfile;

System altered.


SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 5033163648 bytes
Fixed Size                  9038720 bytes
Variable Size             872415232 bytes
Database Buffers         3925868544 bytes
Redo Buffers                7737344 bytes
In-Memory Area            218103808 bytes
Database mounted.
Database opened.
SQL>

 

* [Oracle Version 19.3.0.0.0 On Windows Hyper-V Server 2019 Try In\_Memory - 任国强 - 博客园](https://www.cnblogs.com/rgqancy/p/18010148)
* [Oracle中alter system命令参数之scope - TIMLONG - 博客园](https://www.cnblogs.com/timlong/p/6089680.html)
* [ORA-02095: specified initialization parameter cannot be modified-CSDN博客](https://blog.csdn.net/weixin_51800779/article/details/109507168)
* [Oracle内存占用高过时的调整策略 - 一只竹节虫 - 博客园](https://www.cnblogs.com/dll102/p/14682248.html)