Oracle Upgrade on Windows – London Stock Exchange listed Finance Company
Our client, an AIM-listed independent finance company, provides a range of high quality financial products to both business and personal customers.
The organisation had experienced sustained, strong organic growth over a four year period, with business volumes further increased through acquisition.
Much of that success was accredited to our client’s innovative proposal system, powered by an Oracle database implemented, maintained and supported by Pro DBA.
Rapid Data Growth Brings Challenges
Our client faced the challenge of sustaining good performance from their proposal system while data volumes increased through business growth and the introduction of new product lines.
The existing architecture had served the client well through four years of business growth, but limited hardware scalability and Oracle version obsolescence meant the installation was nearing the end of its useful life.
Pro DBA had worked closely with the client and their application vendor since the proposal system was launched, providing strategic advice where appropriate. Our client therefore recognised the key role that Pro DBA could play in shaping future technical direction.
Designing A Solution Appropriate To Requirements And Budget
Through detailed discussion with the client’s business managers and technical staff, Pro DBA determined that system performance and price were key factors in designing a new hardware platform.
Though high uptime was vital, the business chose not to implement Oracle Real Application Clusters (RAC), Oracle’s highly resilient and scalable clustering technology. This decision was based on cost benefit analysis performed jointly by Pro DBA and the client.
Business continuity had been safeguarded since system launch by a resilient standby database solution. This used Pro DBA’s free archive log ship-and-apply procedures to replace functionality only available in Oracle’s more costly Enterprise Edition product. The client chose to retain this functionality in the new infrastructure.
Implementing The Solution
For a modest investment our client purchased new hardware running Windows Server. Pro DBA recommended both vendor and hardware specification, as a comparable purchase had recently yielded exceptional results for another Pro DBA client with a similar application profile.
Oracle Database software was installed and patched on the client’s new hardware several weeks prior to the scheduled migration date. Rigorous testing then took place using a migrated copy of the production database.
Diligent planning by Pro DBA, the client and the application vendor paid off on go-live day, with the database migration completing without a hitch in less than three hours.
The move to latest Oracle and Windows versions on fast new hardware allowed Oracle to address a much larger data cache, vastly reducing physical disk access and thus improving database performance massively.
Migrating to the latest Oracle version brought additional benefits. Oracle optimizer enhancements and improved PL/SQL efficiency made the system significantly faster than before, even on old test hardware. The version migration also delivered improved supportability and a richer feature set.
The Immediate Future
The results of the project exceeded our client’s expectations, with key application processes running five times faster directly after the migration. Subsequent tweaks and fine-tuning yielded more gains, and the client’s application enjoyed faster-than-ever response times.
The Longer Term
Pro DBA continues to support and patch the system for this client. The system still performs impressively well, backed by Oracle’s unfaltering reliability on Windows.