Performance is one of the key reasons organizations choose the Oracle database. Able to offer performance without sacrificing security, available or integrity, Oracle is the market leader when it comes to enabling companies to get more out of their systems. With each new release of Oracle comes a raft of features designed to allow improved performance from an existing system. However, inevitably with this rapid pace of change it is nearly impossible for those involved in the day-to-day operations of a database to stay abreast of all of the features and facilities available to them.

Building on our experience

As a specialist Oracle partner, e-DBA have built their business around our deep knowledge, and the extensive experience of our consultants, in Oracle and all of the features it makes available to users. The e-DBA Performance Tuning consultancy offerings enable us to share this experience with our customers to ensure they achieve maximum performance from their systems.

Targeted or Holistic

No matter whether you are targeting a specific area, such as the nightly batch process, or just looking to get the best out of the system in general, the e-DBA Performance Tuning service can help. Amongst the services we offer are:

• Problematic SQL statement identification and tuning
• Batch Run analysis
• PL/SQL tuning services
• RAC tuning
• VLDB performance analysis and recommendations
• Resource Contention identification
• Recommendations of new features

Capacity Management / Getting Back Headroom

Over the last few decades, as CPU processing power has grown many organizations “resolved” performance issues by throwing new, improved CPUs, at applications. As we now move into an era of less pronounced growth in CPU speed, and a move to multi-core architectures many find systems bottlenecks by I/O or other factors.

The e-DBA Performance Tuning service is an idea complement to any hardware refresh consideration. By making sure the database is performing optimally, more intelligent decisions can be made on hardware purchase, or consolidation exercises. It is often surprising the impact a fresh set of eyes can bring, working with one client recently we reduced the average CPU utilization from 95% to less than 50%, and reduced average IO operations per hour by 50%, enabling them to consolidate servers instead of increasing the footprint of the system.