Oracle IM 对象使用大小管理建议
IM大小有限制的情况,如何控制准备放入IM对象大小,建议从使用优先级和压缩比率两方面考虑。
对象放入IM后所需空间可从V$IM_SEGMENTS获取。
Estimate the size of the IM column store based on your requirements, and then resize the IM column store to meet those requirements. Applying compression can reduce memory size.
The amount of memory required by the IM column store depends on the database objects stored in it and the compression method applied on each object. When choosing a compression method for the INMEMORY
objects, balance the performance benefits against the amount of available memory:
To make the greatest reduction in memory size, choose the FOR CAPACITY HIGH
or FOR CAPACITY LOW
compression methods. However, these options require additional CPU during query execution to decompress the data.
To get the best query performance, choose the FOR QUERY HIGH
or FOR QUERY LOW
compression methods. However, these options consume more memory.
该案例暂时没有网友评论
✖
案例意见反馈
亲~登录后才可以操作哦!
确定你的邮箱还未认证,请认证邮箱或绑定手机后进行当前操作