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:
Navigate to the database install location (known as
$ORACLE_HOME), and log in to the database:bin/sqlplus / as sysdbaYou 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 Testing options
Run the following...
