oracle support at low prices oracle dba outsourcing oracle database tuning oracle price list
  
oracle case studies ~ Pro-DBA.com Quick page links: case study | contact

case studies
 

 
MIGRATION TO ORACLE 10G 64-BIT - 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 has experienced sustained, strong organic growth over a four year period, with business volumes further increased through acquisition.

Much of that success is accredited to our client’s innovative proposal system, powered by an Oracle Standard Edition database implemented, maintained and supported by Pro-DBA.com.
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.com has 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.com 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.com determined that system performance and price were key factors in designing a new hardware platform.

Though high uptime is 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.com and the client.

Business continuity has been safeguarded since system launch by a resilient standby database solution. This uses Pro-DBA.com’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 an AMD Opteron based 64-bit server running Windows Server 2003 64-bit. Pro-DBA.com recommended both vendor and hardware specification, as a comparable purchase had recently yielded exceptional results for another Pro-DBA.com client with a similar application profile.

Oracle 10g Release 2 Standard Edition One 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.com, 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.
 
BENEFITS GAINED
The move to a 64-bit architecture allowed Oracle to address a much larger data cache, vastly reducing physical disk access and thus improving database performance massively.

Migrating to Oracle 10g brought additional benefits. Oracle optimizer enhancements and improved PL/SQL efficiency make Oracle 10g significantly faster than Oracle 9i, and far faster than Oracle 8i. The version migration has also delivered improved supportability and a richer feature set.

Annual Oracle subscription costs have been slashed by two thirds following the move from Standard Edition to Standard Edition One, giving the client a tangible return on investment.
 
THE 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 have yielded more gains, and fine tuning over the coming months will deliver even better performance.

Our client is now ready to embrace continued business growth, unhindered by technological constraints.
 
Top of page
contact us

To contact us fill in the form below. We guarantee you a quick response. Alternatively you can email us using the contact details below. Just supply your email address (and optionally, brief details of your requirements), and we'll get back to you quickly. Alternatively please call us on 020 8465 9100 (+44 20 8465 9100 from outside the UK).

** fields are mandatory
My email address:

**

Tel no:  
Company name:      
I am interested in:

Support

 Migration/Upgrade
Disaster recovery Development
Tuning Other
Requirements:      
     
Top of page
 

Copyright Pro-DBA.com 1999-2008, all rights reserved. 11 Greenwich Quay, Clarence Road, London, SE8 3EY.