O'Reilly logo

Oracle SOA Suite Performance Tuning Cookbook by Matt Brasier, Nicholas Wright

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tuning the Oracle database

This recipe looks at tuning advanced database options that affect its global behavior. We'll cover changing two items, namely undo space and redo logs.

Getting Ready

You will need access to the backing SOA Suite Oracle database, which needs to be Version 11g r2 or higher. To execute commands, you'll need to be able to log in with the SYSDBA role.

How to do it…

This recipe is split into two parts. First, follow these steps to alter the undo space. Before proceeding, ensure that the database is not processing the production load:

  1. Navigate to the database install location (known as $ORACLE_HOME) and log in to the database:
    bin/sqlplus / as sysdba
    
  2. You will see an output similar to the following code snippet:
    SQL*Plus: Release ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required