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.
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.
Follow these steps to set global database parameters. Before proceeding, ensure that the database is not processing production load:
$ORACLE_HOME), and log in to the database:
bin/sqlplus / as sysdba
SQL*Plus: Release 126.96.36.199.0 Production on Sun Jan 6 12:38:37 ...