How to calculate time based on "Nines" SLA

 

1. The Core Formula (This Is the Only Formula Used)

$$\mathbf{\text{Downtime}}=\text{Total Time}\times (1-\text{Availability})$$

Where:

• Availability is written as a decimal
  (e.g., 99.9999% ⇒ 0.999999)
• Total Time is expressed in the unit you care about
  (year, month, day, etc.)

---

2. Convert 9.9999% Correctly (Common Mistake)

99.9999% is NOT 9.9999

Correct conversion:

$$99.9999\mathrm{\%}=\frac{99.9999}{100}=0.999999$$

Downtime fraction:

$$1-0.999999=0.000001$$

👉 That’s one‑millionth of the time window

---

3. Total Time in One Year

A standard year:

$$365\text{ days}\times 24\times 60\times 60$$

$$=31,536,000\text{ seconds}$$

---

4. Downtime Calculation for 99.9999%

$$\text{Downtime per year}=31,536,000\times 0.000001$$

$$=31.536\text{ seconds per year}$$

---

✅ Final Answer (Core Result)

99.9999% availability allows:

• 31.5 seconds of downtime per year
• ~2.6 seconds per month
• ~0.086 seconds per day

---

5. Year / Month / Day Breakdown

Time Period	Allowed Downtime
Year	31.5 seconds
Month (30 days)	~2.6 seconds
Week	~0.6 seconds
Day	~0.086 seconds

📌 Meaning: A single Oracle cluster reconfiguration already burns the entire daily budget.

---

6. Comparison Across “Nines” (For Perspective)

Availability	Downtime / Year
99.9%	8.76 hours
99.99%	52.6 minutes
99.999%	5.26 minutes
99.9999%	31.5 seconds
99.99999%	3.15 seconds
99.999999%	0.315 seconds

---

7. Architect Reality Check (Very Important)

At 99.9999%:

• One:
  • RAC rebalance
  • Failover detection
  • Network flap
  • Patch‑related pause
• Exceeds the daily or monthly budget

👉 That’s why six‑nines and above are application‑experience claims, not database SLAs.

---

8. Interview / Design‑Review Ready Statement

You can safely say:

“99.9999% availability mathematically permits only 31.5 seconds of downtime per year. At this level, even automated failovers, cluster reconfigurations, or planned maintenance windows must be treated as availability‑impacting events.”

---

9. One‑Line Formula You Can Memorize

$$\boxed{{\displaystyle }}$$Downtime per year=31,536,000×(1−Availability)