Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus memory leak?
"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......