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 Oracle database parameters

In this recipe, we'll tune the database schema that backs our SOA Suite processes. We'll also make some changes to the global database parameters.

Getting ready

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

How to do it…

Follow these steps to set global database parameters. Before proceeding, ensure that the database is not processing 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 11.2.0.1.0 Production on Sun Jan 6 12:38:37 ...

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