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.
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.
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:
$ORACLE_HOME) and log in to the database:
bin/sqlplus / as sysdba
SQL*Plus: Release ...