skills/aws-database/assets/rds-oracle.md

# RDS for Oracle

- **Docs**: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Oracle.html
- **Docs (llms.txt)**: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/llms.txt
- **Data model**: Relational (Oracle Database)
- **Query language**: Oracle SQL, PL/SQL
- **Compatibility**: Oracle Database (Standard Edition 2, Enterprise Edition)
- **Serverless**: No (fixed instance types)
- **Scale to zero**: No
- **VPC required**: Yes
- **Multi-region**: Cross-region read replicas (Enterprise Edition); cross-region automated backups for multi-region DR (Standard Edition 2)
- **Free Tier**: None
- **Min cost**: ~$55/month (BYOL, db.t3.small) or ~$85/month (License Included, db.t3.small)
- **Time to first query**: 15-20 min (VPC + instance + Oracle configuration)
- **Key features**: Oracle Database features (Data Guard, Multitenant, Partitioning, Advanced Compression, APEX, TDE, JVM; RAC not supported on RDS), automated backups, Multi-AZ, monitoring with CloudWatch and Database Insights, Oracle-native tools compatibility
- **Limitations**: Oracle licensing cost, no RAC (use ODB@AWS for RAC), no serverless
- **Best for**: Lift-and-shift Oracle migrations where the database cannot be modernized to Aurora right away. Teams with Oracle expertise but wanting to offload their operational burden with a fully-managed service.
- **Not for**: New applications (use Aurora PostgreSQL or DSQL), cost-sensitive workloads, teams looking to move off commercial licensing (that's a refactor to Aurora PostgreSQL)