Consider the following recommendations for Oracle database on AWS:
- For increased security, deploy the Oracle single instance database in a private subnet.
- Allow only application servers or a bastion host within the VPC to access the database instances.
- Use the c5n EC2 instance family for high computing workloads.
Consider the following tuning recommendations for the Oracle database:
- Create Oracle redo log files with 4k block size.
- Set the Oracle redo logs to fine grained striping of 128 KB.
SQL> ALTER DISKGROUP <diskgroup_name> ALTER TEMPLATE onlinelog ATTRIBUTES (FINE);
- Set Oracle redo log file size to minimize excessive redo log switches.
- Create a bigfile tablespace to simplify datafile management by reducing the number of datafiles and significantly increasing the storage capacity of an Oracle database.
- Ensure that the free disk space exists in the Undo tablespace for maintaining undo records.
- Create a temporary tablespace in a separate ASM disk group.