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 execution time of statements within Batch processes with SLA in medium systems


Results

• Solution and detection of 223 behavior changes associated with statements (control of +150,000 tables)

• Action taken 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 Teleco

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 in the client’s main critical databases.

• More than 100 technical optimizations implemented (batch and online).

Additionally

60%

Average Wait Time Savings

+14TB%

Disk Space Reduction (+95TB pending implementation)

Top 5 Insurer in Spain

Consumption Optimization


Challenges

• A client with annual OCPU costs exceeding €1.5M and an average growth of 22% in the past two years, requiring effective cost containment and reduction.



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 Banks in Spain

Response Time Optimization


Challenges

• Containing and reducing response time increases in digital banking services.

• IImplementation of 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