Oracle DB 21c Standard on Windows

This is a repackaged open source software product wherein additional charges apply for cloudimg support services.

Overview

Oracle Database 21c is Oracle's innovation release featuring the latest database technologies. This AMI provides Oracle DB 21c Standard pre-configured on Windows Server, delivering comprehensive SQL, PL/SQL, and advanced database capabilities for modern applications.

Oracle Database 21c Features

Innovation release. Latest Oracle technologies. New 21c features. Production ready. Security hardened. Performance optimized. High availability. Scalability. Standards compliance.

21c Innovations

Blockchain tables. Native JSON data type. JavaScript stored procedures. Immutable tables. AutoML. Graph analytics. In-memory enhancements.

SQL Engine

SQL query language. ANSI SQL compliance. Complex joins. Subqueries. Window functions. Common table expressions. Analytic functions. Query optimization.

PL/SQL

Procedural language. Stored procedures. Functions. Triggers. Packages. Exception handling. Bulk operations. Collections. Native compilation.

ACID Transactions

Atomicity. Consistency. Isolation. Durability. Transaction control. Commit and rollback. Savepoints. Read consistency. Multi-version concurrency.

Data Types

Numeric types. Character types. Date and timestamp. LOB types. JSON data type. XML data type. Spatial data types.

Indexing

B-tree indexes. Bitmap indexes. Function-based indexes. Composite indexes. Index organized tables.

Partitioning

Range partitioning. List partitioning. Hash partitioning. Partition pruning. Performance benefits.

Security

Authentication. Authorization. Role-based access. User management. Encryption support. Auditing capabilities. Data masking.

Backup and Recovery

RMAN backup utility. Hot backups. Incremental backups. Point-in-time recovery. Flashback technology. Archive log mode.

High Availability

Automatic restart. Redo logs. Archive logs. Flashback database. Standby database support.

Performance Tuning

Automatic Workload Repository. SQL tuning advisor. Execution plans. Optimizer hints. Memory management. SGA configuration. PGA tuning.

Database Objects

Tables. Views. Materialized views. Sequences. Synonyms. Database links. Stored procedures. Functions. Packages. Triggers.

Concurrency Control

Row-level locking. Multi-version read consistency. Deadlock detection. Transaction isolation levels.

Data Integrity

Primary keys. Foreign keys. Unique constraints. Check constraints. Referential integrity.

SQL Developer Tools

SQL*Plus. SQL Developer. Oracle Enterprise Manager. Data Pump. SQL Loader. DBMS packages.

Monitoring

Dynamic performance views. Data dictionary views. Alert logs. AWR reports.

JSON Support

Native JSON data type. JSON queries. JSON path expressions. Document storage. JSON-relational duality.

Application Development

JDBC connectivity. ODBC connectivity. Oracle Call Interface. REST APIs. APEX integration. .NET connectivity.

Storage Management

Tablespaces. Datafiles. Undo management. Automatic storage management.

Networking

Oracle Net Services. TNS listener. Connection strings. Service names. Connection pooling.

Database Administration

Instance management. User administration. Privilege management. Resource management. Job scheduling.

Migration Tools

Data Pump export/import. SQL Loader. External tables. Database links.

Windows Integration

Windows Server 2019. Windows Services. Event Viewer logging. Windows authentication. Active Directory support. RDP access port 3389.

AWS Optimization

EC2 optimized. EBS storage. CloudWatch integration. Systems Manager. Auto scaling ready. VPC support.

cloudimg Support

24/7 support via phone, email, chat. Oracle Database expertise. Installation assistance. Configuration tuning. Performance optimization. Troubleshooting. Migration support.

Use Cases

Enterprise applications. ERP systems. Financial applications. E-commerce platforms. Data warehousing. OLTP workloads. Business intelligence. Blockchain applications.

FAQ

Q: Which Windows versions supported?

A: Windows Server 2019.

Q: Is this Standard Edition?

A: Yes, Oracle DB 21c Standard.

Q: What new 21c features included?

A: Blockchain tables, native JSON, JavaScript procedures, immutable tables.

All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.