Success stories
Success stories – Oracle database optimization
Lower resource consumption, reduced costs and improved user experience in major telco, banking and insurance companies
TOP 5 banking Spain
Resource optimization
Challenges
- Reduce resource consumption and improve database stability.
- Reduce the execution time of statements within batch processes with SLAs on midrange systems.
Results
- Solution and detection of 223 behavior changes associated with statements (control of 150,000+ tables).
- Action on existing technical debt across a total of 279 components (batch and online).
Additionally
61%
Average CPU savings
24%
Average I/O savings
66%
Average elapsed time savings
TOP 5 Telco
Resource optimization
Challenges
- Optimize resource consumption and waiting times in critical services.
- Optimize parameters and key points of the Oracle database configuration.
- Reduce disk storage usage.
Results
- Health check, analysis and improvement proposals for the client's main critical databases.
- More than 100 technical optimizations implemented (batch and online).
Additionally
60%
Average wait time savings
+14 TB
Disk space savings (+95 TB pending implementation)
TOP 5 insurer in Spain
Consumption optimization
Challenges
- A client with annual OCPU costs of over €1.5M and an average growth of 22% in the past two years, needing to contain and reduce costs.
Results
- Remediation of existing technical debt across 87 components.
- Solution and detection of 4 monthly behavior changes associated with Oracle (250,000+ distinct statements).
Additionally
15%
OCPU reduction
56%
Average duration savings
TOP 10 banking Spain
Response time optimization
Challenges
- Contain and reduce response time increases in digital banking services.
- Implement mechanisms to identify and mitigate response time increases caused by software behavior changes.
Results
- Average saving of 1,210 ms in response time per improved component.
- Solution and detection of 2 monthly behavior changes associated with Oracle (15,000+ distinct statements).
Additionally
93%
Average reduction in database access response times
17h
Average development effort per improvement