home technical personal links weddings
spacer general tech mapinfo/gis oracle/database misc/useless

Information on DB Availability

Availability Needs
Availability Requirement Acceptable Downtime Critical Success Factor
6 x16 All day Sunday and 8/hours/night Acceptable function and performance
96%; 7x24 14.6 days a year Online archiving
98%; 7x24 7.3 days/year 99% proacion
99%; 7x24 3.7 days/year Staged upgrades
99.5%; 7x24 1.8 days/year High-availability cluster
99.8%; 7x24 17.5 hours/year Off-site redundant-everything
99.97%; 7x24 2.5 hours/year Auto-failover
99.995%; 7x24 0.5 hours/year Instant online expert readiness, standy database or geo mirroring


Disk-Failure Frequency (1 2GB disk MTTF 100,000 hours)
Database Size (GB) Number of Disks MTTF (hours) Failure Frequency (days)
16 8 12,500 520.83
64 32 3,125 130.21
128 64 1,563 65.10
256 128 781 32.55
512 256 391 16.28
1,024 512 195 8.14
2,048 1,024 98 4.07
4,096 2,048 49 2.03


for questions/comments: kgmahoney@yahoo.com   © 2001-2017 kmahoney.com