Re: Oracle 9.2.0.5, RedHat 7.3 (2.4.27) and SGA size 2.7GB

andrej_at_rikom.si (Andrej Trobentar) wrote in message news:<59127cb2.0503080139.52d90c3e_at_posting.google.com>...
> Hello all,
>
> My problem :
> I'm trying to increase the SGA to 2.7 GB.
>
>
> What have I done so far :
>
> 1) I have succesfully installed the above mentioned database following
> the HOWTO http://www.puschitz.com/InstallingOracle9i.shtml#RunningOracleInstallation.
> The database is working without problems, but uses only 1.7GB of
> memory for SGA.
>
> 2) I have followed the excelent HOWTO from Werner Puschitz located on
> http://www.puschitz.com/TuningLinuxForOracle.shtml#IncreasingSpaceForLargerSGA,
> but when I come to the point for changing the mapped base on Linux OS
> level, I'm unable to locate the file /proc/<pid>/mapped_base, and my
> /proc only says (5390 is the PID of oracle shell):
>
> [root_at_server root]# ls -al /proc/5390/
> total 0
> dr-xr-xr-x 3 oracle dba 0 Mar 8 10:14 .
> dr-xr-xr-x 69 root root 0 Mar 7 15:29 ..
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 cmdline
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 cpu
> lrwxrwxrwx 1 oracle dba 0 Mar 8 10:14 cwd ->
> /home/oracle
> -r-------- 1 oracle dba 0 Mar 8 10:14 environ
> lrwxrwxrwx 1 oracle dba 0 Mar 8 10:14 exe ->
> /bin/bash
> dr-x------ 2 oracle dba 0 Mar 8 10:14 fd
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 maps
> -rw------- 1 oracle dba 0 Mar 8 10:14 mem
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 mounts
> lrwxrwxrwx 1 oracle dba 0 Mar 8 10:14 root -> /
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 stat
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 statm
> -r--r--r-- 1 oracle dba 0 Mar 8 10:14 status
> [root_at_server root]#
>
> So, NO mapped_base in here. What am I doing wrong?
>
> I have even tried to download the latest kernel source for RH EL 4
> (2.6.9-5.EL)
> and recompiled it, but again, no mapped_base in proc.
>
> I have a HP ProLiant ML370 server with 2 Intel(R) Xeon(TM) CPU 3.20GHz
> processors and 4GB of RAM.
>
>
> Many thanks for all help and have a nice day.

'What am I doing wrong?'
Thinking you can resolve performance problems by throwing memory at it, instead of tuning your sql statements. Oracle has always stated a SGA shouldn't exceed 33 percent of physical RAM.
Anyone who thinks that bumping the SGA to 2.7G in a system with only 4G RAM will resolve anything, doesn't realize he will end up with a system, that is heavily page-faulting all of the time. Please reconsider. This rash measure is not going to help you one single bit.

Sybrand Bakker
Senior Oracle DBA Received on Tue Mar 08 2005 - 10:12:00 CST