Re: Memory Sizing and Usage

From: Michael Abbey <msabbey_at_magi.com>
Date: 1996/02/17
Message-ID: <4g4jmg$jhb_at_news.magi.com>#1/1


By using O/S monitoring screens (such as top or monitor) you can determine the shared and private memory requirements. In my book Tuning Oracle, chapter 2 is dedicated to just this exercise. Please consult for further details.

Michael

pallison_at_ppg.com wrote:

>Does anyone know the amount of real memory an Oracle user
>process uses.
 

>In the Oracle7 AIX 3.2.5 Installation Guide section on sizing,
>Oracle says that each additional user requires 482 Kb of memory.
 

>The following is the result of a "ps gu" command. The man file says that
>the %MEM column is the percentage of real memory that the process is
>using.
 

>USER PID %CPU %MEM SZ RSS TTY STAT STIME TIME COMMAND
>ccc18 18959 0.0 2.0 312 3948 - S 10:35:39 0:00 oraclect01 P:4096,6,9,
>ccc18 20503 0.0 0.0 96 232 pts/3 R 10:36:19 0:00 ps gu
>ccc18 23566 0.0 1.0 524 1732 pts/3 S 10:35:35 0:00 sqlplus ccc18
 

>As far as I know I have 256 meg RAM.
 

>How can I translate the %MEM numbers to the estimate??
 

>2% of 256M is 5M. This can't be right.
Received on Sat Feb 17 1996 - 00:00:00 CET

Original text of this message