Re: AW: Query on Linux 'top' command for oracle user

> Yes too bad it's not available on <RHEL5,

I don't know if this command can help you:

#Red Hat 4, sum of Oracle $ORACLE_SID instance process resident memory 
(supposedly private)
SGA=<number from `show sga' sqlplus command>
(for i in `ps -fu oracle | grep $ORACLE_SID | grep -v grep | awk '{print $2}'`; 
do  echo "`ps -orss= -p $i`*1024-$SGA" | bc; done) | awk '{sumrss+=$1} END 
{print sumrss}'

If the above is messed up, go to
http://yong321.freeshell.org/osnotes/FreqCmds.txt

> the same way I'm feeling  for iotop here 
> http://people.redhat.com/jolsa/iotop/ which is a very useful tool

For older Linux, just use atop:
http://www.atoptool.nl

I thought iotop was written by Guillaume Chazarain at
http://guichaz.free.fr/iotop/
But maybe they somehow work together.

Ever since kernel 2.6.18-164 added /proc/<pid>/io, it's a simple matter 
of reading and sorting. Even I can write a program to do it, called topio:
http://yong321.freeshell.org/freeware/pio.html#linux
and it's just two simple Perl scripts. No RPM is needed. Slightly before 
kernel 2.6.18-164, you may be able to have /proc/<pid>/io by configuring 
TASK_DELAY_ACCT and TASK_IO_ACCOUNTING in kernel and rebuild.

Yong Huang


      
--
http://www.freelists.org/webpage/oracle-l

Other related posts: