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.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南