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 11.2.0.1.0 Production on Sun Jan 6 12:38:37 2013
   Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:
   Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
   With the Partitioning, OLAP, Data Mining and Real Application...