Determining the size of oracle processes without the glance utility

[Augusto Vinhaes]

Hi all !
I've got some oracle processes running in a unix box and I need to determine the following:

- the size of text area
- size of shared memory area
- size of data area
- size of stack area

I don't have Glance in this machine and the "ps" command doesn't show what I need.
In the Solaris, there is the pmap command that is bundled and gives all the information.

Regards,
Augusto

[Sundar_7 · Accepted solution]

Hi,

Download the attached procsize.sh in to your system and execute the script. it will create procsize binary.

# /root/procsize -p

Sundar

[Nicolas Dumeige]

You seems to know your way around on this.
In any case, check that metalink.oracle.com Note:174555.1 UNIX: Determining the Size of an Oracle Process

[Geoff Wild]

Here's a short script to just get memory by a user:

#!/bin/ksh
# usermem - display memory claimed by a user
#
if [ $# -lt 1 -o \( $# -gt 1 -a $# -lt 4 \) ]
then
echo "Usage:"
echo "usermem \"userid\""
echo "Example:"
echo "usermem oracle"
exit 1
fi
echo " "

USER=$1
t=0
for j in `UNIX95= ps -e -o vsz=Kbytes -o ruser -o pid,args=Command-Line | sort -rnk1 | grep -v Kbytes | grep $USER | awk '{print $1}'`
do
t=`expr $t + $j`
done
echo "\nMemory claimed by $USER: $t Kbytes.\n"


Output like:

# usermem oracle

Memory claimed by oracle: 16204272 Kbytes.



Rgds...Geoff