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