By using AWS re:Post, you agree to the Terms of Use

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?

1 Answers
0

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.

answered a month ago
  • 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.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions