Re: memory process use is 10M is that normal?mlml

Hi Michel,

if You want to know how many memory is allocated by Your shadow processes, You can use the following statement:

    SELECT p.spid, v.sid, v.value

       FROM v$process p, v$session s, v$sesstat v, v$statname n
     WHERE p.addr = s.paddr
          AND s.sid = v.sid
          AND v.statistic# = n.statistic#
          AND n.name = 'session pga memory max';

If You see more memory with OS tools than they maybe shows You the memory inclusive the shared part (SGA). But 10MBytes is not to high for a shadow process.

--
Best Regards,

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third-party organizations.

Michel Lee wrote:

> I am using Dedicated Server process as oppose to MTS.
> so on in HPUX10.20 , ORACle 7.3.4
> each user connection creates a process like :
> oracleSIDNAME
>
> using 'top' this process takes up 10M of memory!
> (maybe i am interpreting this number wrongly)
>
> We have many users, e.g. 100 so, they all take up
> 100*10M=1000M=1G memory.
>
> This is creating 'out of mem' errors.
>
> My qustion is:
> Is that normal?
> What do i do to reduce this 10M per process mem usage?
>
> cheers
> Mike
> --
> /-----------------------------------------------/ \--\--\ \-- \-- \--
> / www.ncf.carleton.ca/~ae299 /---\ \ \ \\ \ \
> / ae299_at_freenet.carleton.ca /-----\ \ \\-- \-- \--
> /-----------------------------------------------/
Received on Wed Jul 21 1999 - 13:33:05 CDT