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回答
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.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ