- Newest
- Most votes
- Most comments
Amazon RDS for Oracle does not support the Automatic Fragment Advisor or the Automatic Segment Space Management feature of Oracle. However, RDS provides monitoring tools that can help you identify and address fragmentation issues.
One of the tools that RDS provides is the Oracle SQL monitoring feature, which allows you to monitor the SQL statements that are being executed on your database. This can help you identify SQL statements that are causing fragmentation issues, such as large insert or update statements. You can also use the Amazon RDS Performance Insights feature to monitor database performance and identify any performance bottlenecks.
In addition, you can use the Oracle Analyze Table command to gather statistics on table and index objects, which can help you identify fragmentation issues. You can also use the Oracle Segment Advisor to identify segments that are candidates for defragmentation.
It's important to note that Amazon RDS takes care of many of the administrative tasks associated with managing an Oracle database, such as backups, software patching, and hardware maintenance. However, it's still your responsibility to monitor the performance of your database and address any issues that arise.
Relevant content
- asked 2 years ago
- asked 22 days ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 6 months ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated a month ago
Thank you very much for answering the question in detail. I still have one point to confirm, which is whether Automatic Segment Space Management is supported on RDS or not? And if it is supported, will there be any additional costs incurred? According to Oracle documentation, this feature is mentioned on slide 63 in this link: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/database-performance-tuning-guide.pdf "Permanent Tablespaces - Automatic Segment-Space Management For permanent tablespaces, Oracle recommends using automatic segment-space management. Such tablespaces, often referred to as bitmap tablespaces, are locally managed tablespaces with bitmap segment space management."
And a member on the dba forum also confirmed that it is supported by default for all new permanent, locally managed tablespaces: https://dba.stackexchange.com/questions/326494/how-can-i-monitor-and-address-fragmentation-on-rds-for-oracle-database