RDS Oracle In memory feature

0

I want to setup RDS oracle instance and use In-Memory feature of Oracle DB. For testing this, I have use standard edition and try to set "inmemory_size" to some GB's using Admin user. This is the same user which I used during building RDS instance. I am getting permission error. Is Admin user not have permission to alter system tables? Does Oracle RDS supports in-memory feature? If yes how I can set "inmemory_size"? which user I need to use?

已提问 2 年前626 查看次数
1 回答
1

Hello,

Amazon RDS for Oracle does support Oracle In-memory feature. See: https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/Oracle.Concepts.FeatureSupport.html

However, Oracle Enterprise Edition is a requirement for this extra-cost option. See: https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-0F9EB85D-4610-4EDF-89C2-4916A0E7AC87

Please use Amazon RDS for Oracle with Oracle EE and let us know if the problem still persists.

Regards,

Govardhanan.

profile pictureAWS
专家
已回答 2 年前
  • Thanks Govardhanan_R. But if I go with Oracle Enterprise Edition, there is no option for included license. I have to use my own license. Can you provide estimation of changes for license and this EE-ES: Extra cost option charges. and If I go with EE can admin user will get permission to alter system tables?

  • For BYOL option, you need to contact Oracle for the applicable license charges. Same goes for what you need to cover the in-memory option.

    As for the system privileges that the admin user has, you can reference the documentation: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html. To get the list of table privileges that the admin user has, you can always query the data dictionary view USER_TAB_PRIVS while logged into the database as ADMIN.

    Hope this helps. Given the fact that Amazon RDS for Oracle supports in-memory option, I would expect that necessary privileges are in place. In case you still see any issue, please let us know which table you are trying to alter and why (with Oracle documentation reference if possible). I would also recommend an AWS support case if you deem that as an issue for us to resolve and you need help quickly. Thanks.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则