Whilst working for a client with a large Oracle estate, supporting high transaction systems, we found that the in-built auto-extend feature, designed to increase the size of the tablespaces automatically was actually making Operational Capacity Management harder.
Given nothing but the size of the database it was difficult to apportion the amount of growth due to real business demand and how much was just auto-extend kicking in. This made it harder to accurately predict the amount of life left in the system, the critical question we were trying to answer in order to ensure service continuity.
In databases exhibiting high storage utilisation auto-extend was even more dangerous as there was a strong likelihood of it trying to claim a larger block of space than was needed or available and bringing down the system as a result.
The solution in this scenario? Just switch it off for highly utilised databases.
It makes me wonder what other foes might be lurking out there with friendly capacity management masks on…
About the author
Team Capacitas
FinOps and AI: Building the Financial Discipline for the Next Wave of Enterprise Intelligence
AI FinOps represents an evolution rather than a replacement of traditional FinOps. It extends the model into a domain where financial, technical, and product decisions are tightly interconnected.
Confidence Under Load: How We Verified AKS Readiness for Peak
How Capacitas verified AKS readiness for peak demand by validating workload performance, autoscaling, cluster capacity, monitoring, and incident response.
Building Cloud Resilience: Lessons from the AWS Outage
Learning from the Latest Outage. Events like this week’s AWS disruption highlight one clear truth: resilience must be designed, not assumed.
Bringing Order to Chaos: A Practical Guide to Chaos Testing in the Cloud
In today’s cloud-native environments, resilience is not optional—it’s critical. Chaos testing has emerged as a key practice for validating system behaviour under failure conditions.