Owner's Manual

Troubleshooting 9
Troubleshooting
This section provides recommended solutions for issues that you may
encounter while deploying and using your Enterprise Linux
®
and
Oracle
®
software.
Performance and Stability
Enterprise Linux Exhibits Poor Performance and Instability
Poor performance and instability occurs when the size of the Oracle System
Global Area (SGA) exceeds the recommended size.
NOTE: Ensure that the SGA size does not exceed 65 percent of the total system RAM.
To decrease the SGA size:
Enter free at the command prompt to determine the total RAM and reduce
the values of db_cache_size and shared_pool_size parameters in the Oracle
parameter file accordingly.
Unknown Interface-Type Warning is Displayed in the Oracle Alert File
The issue occurs when the public interface is configured as cluster
communications (private interface). This leads to poor system performance.
To resolve this issue, perform the following steps on one node to force cluster
communications to the private interface:
a Log in as oracle .
b Enter sqlplus "/ as sysdba" at the command prompt.
The
SQL> prompt appears.