Oracle IM SIZE在CDB架构中的管理
CDB设置的inmemory_size为总值,各个PDB设置的值综合在实际使用中不得超过CDB设置值。
参考如下:
Before tables or materialized views can be populated into the IM column store, you must enable the IM column store for the database.
In this context, "database" is a non-CDB, CDB, or PDB. In a CDB, the INMEMORY_SIZE
setting in the CDB root determines the overall size of the IM column store. By default, all PDBs have access to the IM column store.
Within an individual PDB, you can limit access to the shared In-Memory Area by setting INMEMORY_SIZE
to a different value. For example, in a CDB with 100 PDBs, you could set INMEMORY_SIZE
to 16G
at the CDB level, and then set INMEMORY_SIZE
to 10G
in one PDB, to 6G
in a second PDB, and to 0
in the remaining PDBs.
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作