Re: Memory Sizing and Usage

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.

If the oracle server process listed in the post is the first oracle server process spawned for the given instance, then the 5M figure is correct. The phrase 'each additional user' refers to each additional user after the first. Read the section on sizing in the Installation Guide again, and note the '#1 User' column under Memory Space Requirements.

regards,
Chuck

-- 
********************************************************************
Chuck Wolfe
Senior Consultant
TELOS Consulting Services
cwolfe_at_ix.netcom.com

I don't want the world, I just want your half...

********************************************************************