Re: Memory Hungry processes: 7.1.3 on Solaris
Date: 3 Aug 1994 10:58:40 GMT
Message-ID: <31nt90$lnd_at_dcsun4.us.oracle.com>
dfd_at_epsilon.com (Devan F. Dewey) writes:
>Has anyone else experienced that Oracle SQL*Net processes are extremely
>hungry for memory? In the range of hundreds of meg per process.
>
>It's causing us a lot of pain and I was wondering if anyone knew why and
>maybe even how to fix it.
>
When you see a shadow process consuming over 5MB per process, you are looking at output from a monitor that shows the virtual size of the process including shared memory it has used (i.e. Oracle SGA pages).
This means it is not using 50MB, it may be 2MB plus 48MB of data pages it read from the SGA (but did not grab 48MB of new RAM).
Check the definition of the utility's column you are watching.
An example would be to compare the SZ to RSS columns that are output from the Unix System V ps command (one shows real size and one includes data and stack pages -> SGA pages).
-=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()} David Natelson Oracle Corporation dnatelso_at_oracle.com -=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()}>]:=--=:[<{()} Received on Wed Aug 03 1994 - 12:58:40 CEST