Before you pick an Azure target, run the Oracle assessment you're probably skipping

Short summary

Before choosing an Azure migration target, comprehensively assess your Oracle workload using SQL queries to discover active features, schema complexity, and performance baselines. The author emphasizes making discovery repeatable through structured artifacts rather than manual spreadsheets, and provides free open-source assessment scripts that can be regenerated per environment to inform target selection and TCO sizing.

• •Query dba_feature_usage_statistics to identify all active Oracle features before selecting a migration target
• •Profile schema complexity using object counts and data types to determine if migration is lift-and-shift or refactor
• •Capture AWR/V$ performance baselines to establish defensible performance gates post-migration

Generated with AI, which can make mistakes.