Sizing guidelines for storage capacity on Oracle systems
When sizing storage capacity for an Oracle system, you need to consider the following Oracle database components:
- Database files
- Online REDO log files
- Backup/flash data
Storage capacity
Database element | Space requirement | 20,000 nodes | 50,000 nodes | 100,000 nodes | 150,000 nodes | 200,000 nodes |
|---|---|---|---|---|---|---|
Database files | DB size | 20 GB | 50 GB | 100 GB | 150 GB | 200 GB |
Temporary tablespace | DB size * 0.2 | 4 GB | 10 GB | 20 GB | 30 GB | 40 GB |
System/undo tablespace | DB size * 0.1 | 2 GB | 5 GB | 10 GB | 15 GB | 20 GB |
Online redo logs | DB size * 0.2 | 4 GB | 10 GB | 20 GB | 30 GB | 40 GB |
Archive logs | DB size * 1.0 | 20 GB | 50 GB | 100 GB | 150 GB | 200 GB |
Backup/flash data | DB size * 2.0 | 40 GB | 100 GB | 200 GB | 300 GB | 400 GB |
Total |
| 90 GB | 225 GB | 450 GB | 675 GB | 900 GB |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*