I'm planning to migrate my database from on-premises to AWS RDS for Oracle. However, I'm not sure if Amazon RDS supports tools such as Automatic Fragment Advisor or the Automatic Segment Space Management feature of Oracle to control fragmentation issues. I have tried searching on AWS documentation and Google but I haven't found any official information confirming this.

1 Answer 1


"Automatic Fragment Advisor" - no such thing exists in Oracle. If you mean "Automatic Segment Advisor", that exists in all recent Oracle database versions, in AWS RDS for Oracle too.

Automatic Segment Space Management - this has been the default for user tablespaces for so many years, it is not even mentioned. Yes, tablespaces are created with ASSM by default, in AWS RDS for Oracle too.

  • Thank you very much! It's taken me a lot of time. Just one more question please, do you think we still need to monitor fragmentation with Automatic Segment Space Management enabled? Apr 27 at 8:46
  • @PhúTrịnh Maybe, but I wouldn't make it high priority. A simple script with DBMS_SPACE.SPACE_USAGE can be used to report the status of objects occasionally. Apr 27 at 9:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.