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

From: Andrej Trobentar <andrej_at_rikom.si>
Date: 8 Mar 2005 01:39:48 -0800
Message-ID: <59127cb2.0503080139.52d90c3e@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. Received on Tue Mar 08 2005 - 03:39:48 CST