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.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인