Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus memory leak?

Re: sqlplus memory leak?

From: Christoph Purrucker <gugi_at_bigfoot.de>
Date: Thu, 26 Jun 2003 16:09:53 +0200
Message-ID: <bdeurn$9n1$1@home.itg.ti.com>


> I use xosview. It dynamically shows the used+share/cache/buff/free mem
> (+disk usage, CPU usage, swap, interrupts).
> If I use top +M (nice! didn't know that) I see the following:
>
> PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
> 1548 root 9 0 22632 22M 1828 S 0.0 2.2 0:00 X
> 1378 t13dba 9 0 14164 13M 13448 S 0.0 1.3 0:00 oracle
> 1341 t13dba 9 0 13180 12M 12436 S 0.0 1.2 0:00 oracle
> 1309 t13dba 9 0 12828 12M 12092 S 0.0 1.2 0:00 oracle
> 1345 t13dba 9 0 9280 9280 8732 S 0.0 0.9 0:00 oracle
> 1311 t13dba 9 0 6916 6916 6468 S 0.0 0.6 0:00 oracle
> 1380 t13dba 9 0 6912 6912 6464 S 0.0 0.6 0:00 oracle
> 1343 t13dba 9 0 6856 6856 6408 S 0.0 0.6 0:00 oracle
> 1554 root 8 0 6596 6596 5912 S 0.0 0.6 0:00 kdm
> 1366 t13dba 9 0 5940 5940 5336 S 0.0 0.5 0:00 oracle
> ......
> ... etc

This means, that there are no really huge processes... So there must be many, many proceses, if memory is filled, and then there is the question, what and whose processes they are. But I can't check that, because You did not print the top-'header' (mem, processes, load)...

cp Received on Thu Jun 26 2003 - 09:09:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US