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)