Re: Memory size of SQL*NET dedicated server processes?

From: Phil Herring <revdoc_at_uow.edu.au>
Date: 1997/08/17
Message-ID: <5t8280$nna$1@wyrm.its.uow.edu.au>#1/1

(Newsgroups trimmed)

In article <33F51409.CFD03A6B_at_fast.net> Steve, scheng_at_fast.net writes:
>I was told that the memory size of SQL*NET server process should be
>around 3Mb. But on our machine, the swappable memory size of SQL*NET
>dedicated server processes (on server machine--Sun E3000) is 16Mb.

How are you determining this figure? Unix often has problems distinguishing between shared memory and program memory - 16M sounds like you're seeing part (or all) of your SGA included in the memory "owned" by the process. For example, this is one instance on a Sparc that I look after:

$ ps -lp "29910 29905 29911 29907 29906 29900 16903 29895 16892"

 F S   UID   PID  PPID  C PRI NI     ADDR     SZ    WCHAN TTY      TIME CMD
 8 S   500 29910     1  0  41 20 f6633670  10665 f5e7d09c ?        0:53 oracle
 8 S   500 29905     1  0  41 20 f621e998  10634 f5e7d04c ?       53:56 oracle
 8 S   500 29911     1  2  54 20 f68b9008  10911 f5e7d0ac ?       229:44 oracle
 8 S   500 29907     1  0  41 20 f69579a0  10762 f5e7d06c ?       17:31 oracle
 8 S   500 29906     1  0  51 20 f59679a0  10641 f5e7d05c ?        8:40 oracle
 8 S   500 29900     1  0  41 20 f621d018  10728 f5e7d03c ?       179:48 oracle
 8 S   500 16903 29895  9  89 20 f6689cc8  10779 f5e7d0cc ?       50:22 oracle
 8 S   500 29895     1  0  40 20 f61c5670  10617 f5e7d02c ?        0:43 oracle
 8 S   500 16892 29895  0  41 20 f668a328  10783 f5e7d11c ?        7:14 oracle

$ pagesize
4096
$

Now, this implies that the total memory used by the instance is:

96520 * 4096 = 377M

...which would be a lot for a system with 96M of real memory. And no, it doesn't swap much at all :-)

Moral of the story: ps sometimes lies to you. So does top.

Received on Sun Aug 17 1997 - 00:00:00 CDT