Oracle IM启动设置过程
前提条件:
Prerequisites
This task assumes that the following:
The database is open.
The
COMPATIBLE
initialization parameter is set to12.1.0
or higher.The
INMEMORY_SIZE
initialization parameter is set to0
(default).You want to use the Database In-Memory Base Level.
操作过程如下:
In SQL*Plus or SQL Developer, log in to the database as a user with administrative privileges.
Set the
INMEMORY_SIZE
initialization parameter to a nonzero value.When you set this initialization parameter in a server parameter file (SPFILE) using the
ALTER SYSTEM
statement, you must specifySCOPE=SPFILE
.For example, the following statement sets the In-Memory Area size to 16 GB:
ALTER SYSTEM SET INMEMORY_SIZE = 16G SCOPE=SPFILE;
For the Database In-Memory Base Level, set the
INMEMORY_FORCE
initialization parameter toBASE_LEVEL
.For example, the following statement specifies the Base Level:
ALTER SYSTEM SET INMEMORY_FORCE=BASE_LEVEL SCOPE=SPFILE;
You cannot set
INMEMORY_FORCE=BASE_LEVEL
at the PDB level. Also, you cannot set this parameter dynamically.Shut down the database, and then reopen it.
You must reopen the database to initialize the IM column store in the SGA.
Optionally, check the amount of memory currently allocated for the IM column store:
Note:
After the IM column store is enabled, you can increase its size dynamically without reopening the database.
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作