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