Analyze Amazon RDS for Oracle database object dependencies
Database Blog
This article provides a tool and walkthrough to analyze dependencies between database objects in a monolithic Oracle database. The tool helps visualize interdependencies to aid in modernizing and migrating the database to AWS.
Specifically, the article covers:
- Overview of the database object dependency analysis tool
- Prerequisites for using the tool
- Gathering database object metadata using SQL queries
- Step-by-step walkthrough to install dependencies, run queries, build the schema graph, and analyze results
- Generating usage reports to see what objects depend on a given object
- Reviewing database object statistics
- Visualizing object dependencies in an interactive graph
- Cleanup steps
- Conclusion and additional resources
The AWS News Feed is currently looking for gold sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.
Related articles
Oct 24
2024
2024
Amazon RDS for Oracle now supports Oracle Application Express (APEX) Version 24.1
Sep 11
2024
2024
Migrate an Oracle database to Amazon RDS for Oracle using Oracle GoldenGate Microservices Architecture
Sep 5
2024
2024
Amazon RDS for Oracle now supports OEM and OLS options with Multitenant configuration
Nov 7
2024
2024
Amazon RDS for Oracle now supports October 2024 Release Update
The AWS News Feed is currently looking for silver sponsors. If you want to support the AWS community and reach a large audience of AWS professionals, consider sponsoring the AWS News Feed.