Capacity Increase: Not Always the Answer to Oracle System Optimisation

capacity increase oracle system optimisation

In many instances of Oracle system optimisation, businesses consider a capacity increase as the first course of action. That is often a mistake. In my experience, 8 out of 10 times, an expansion isn’t needed to solve a problem, and just ends up an unnecessary and untimely cost.

Here are some surprising statistics we’ve seen from working in this space for the last 20 years.

  • 80% of the fixes we’ve provided have not required any additional infrastructure or capacity spending.
  • Most of the fixes have been just using the capabilities of the database platform better.
  • In the last five years, 95% of fixes have not required upgrades or capacity spending.

So before you upgrade, check if you actually need one, you could save thousands of dollars, even millions depending on the size of your existing system.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

12 Performance Benefits from a Oracle Database 12c Upgrade

upgrade to Oracle 12c

Upgrading your Oracle database platform is one of the most strategic IT projects an organisation will undertake.

Whilst this upgrade is a relatively straightforward process, it will typically be linked to an infrastructure platform migration, or can be tied to a major application upgrade.

We will discuss the main performance related features in Oracle 12.2 that will directly benefit your organisation – enabling your systems to run faster or reducing the effort required to maintain and operate your critical Oracle database platforms.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

First Steps to Defining Your Oracle Database Performance Problem

upgrade to Oracle 12c

Clearly defining your Oracle database performance problems is one of the most important steps in resolving system performance issues.

With this in mind, how can you help your technical teams resolve issues more quickly and with less risk?

In this post, we’ll look at how to clearly define performance problems and start the process of improving that performance in a structured and methodical way.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

3 Practical Ways to Improve Oracle Database Performance

improve Oracle database performance

Confirming that you have an Oracle database performance issue is the first step in improving the process. Having defined the level of the problem you need to start solving it.

While the detail of database performance optimisation can be complex, there are three overarching approaches that you need to review.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

How to Reduce the Performance Risk of an Oracle Database Upgrade

reduce performance risk of an Oracle database upgrade

When planning on an Oracle database upgrade, to maintain software currency or utilise new features, there are a number of things that can be done to minimise the risk of poor Oracle database performance after the upgrade.

If there are existing performance problems make sure to have a good understanding of what they are from a technical and non-technical perspective. Fix the low hanging fruit prior to the upgrade, or alternatively during the Oracle database upgrade project.

Running on the latest Oracle releases can provide new functionality that can significantly reduce the cost and complexity to resolve existing Oracle performance issues.

We have included a few points to keep in mind when planning to upgrade to the latest Oracle database releases.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

The IT Managers Guide to Oracle Performance Tuning

upgrade to Oracle 12c

Despite significant advances in the Oracle database optimiser and the supporting platform infrastructure, we as IT Managers still see poor Oracle database performance across a diverse range of workloads.

There are well documented methodologies and tools available to diagnose and resolve Oracle performance problems.

What we don’t see much of are the high-level steps an IT Manager can take to identify causes of poor Oracle performance and usable solutions to resolve Oracle performance problems.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

The Business Cost of Poor Oracle Performance

Cost of Poor Oracle Performance

Optimising and tuning Oracle systems for optimal performance is a well-covered topic. There a range of tools and methodologies to help support engineers to resolve system performance issues.

Why, with all of this in place, are there still so many poorly performing Oracle systems – perhaps even yours?

Why is it that with the significant investments made in Oracle technology, many organisations are still constrained by the performance of their database systems?

The answer is, we often don’t understand the underlying business cost.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.

Oracle Database Flashback Physical Standby

Oracle Flashback Physical Standby Database

This third instalment covering some of the flashback features in Oracle 10g takes a look at combining flashback with using a physical standby. I will take a look at two usage scenarios in which I think could offer significant benefit to anyone using Oracle Database Flashback with a physical standby. This post will cover the use of the physical standby as a read/write copy of a production database.

Mark Burgess has been helping organisations obtain the maximum value from their data management platforms for over 20 years. Mark is passionate about enabling secure, fast and reliable access to organisations data assets.