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: Pim <pimreinders_at_planet.nl>
Date: 26 Jun 2003 06:16:05 -0700
Message-ID: <c71d32c2.0306260516.4cf1540e@posting.google.com>


"Christoph Purrucker" <gugi_at_bigfoot.de> wrote in message news:<bde73t$dfd$1_at_home.itg.ti.com>...
> > The problem however is that the memory is not freed when no scripts
> > are active. Rebooting the computer seems to be the only remedy to
> > reclaim mem.
> > Pim
>
> How do You check the memory? Using top You can sort all processes
> by memory usage (press M). Please tell us, what processes using
> most mem. vmstat is a also a very nice tool!
>
> cp

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 Received on Thu Jun 26 2003 - 08:16:05 CDT

Original text of this message

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