From: Jim McDonald (jmcdon23@CSC.COM.AU)
Date: Tue Apr 01 2003 - 16:33:20 EST
Hi
Having similar problems - still investigating, suspect resource allocation
i.e. paging space and memory too small
As regards memory leakage. - could not find any from oracle based on the
script below.
--------------------------------------------------------------------------------------------------------------------
Theory from
http://publib16.boulder.ibm.com/pseries/en_US/aixbman/prftungd/2365c72.htm#i46342
According to the theory if Inuse, Pin. Pgsp and Virtual [address range ??]
are increasing
then you have memory leak. Apparently they do not all have to grow.
There is a slight
error in the documentation in that it refers to address range but the
output is "Virtual", in
AIX 433 it gives "Address Range" - looks like a bit of cut and pasting was
done to update documentation.
|< -------
these increase->|
PID Vsid Esid Type Description LPage Inuse
Pin Pgsp Virtual
# 1310738 74c38 f00000002 work process private - 13
7 1 14
The real problem is actually locating a suspect process.
The script
#!/bin/ksh
# Script leak_tst.sh run as root with:
# $1 = the number of "top" memory processes
# $2 = the interval ,in seconds, between each run.
# $3 = the number of runs
# Creates a snap shot process ID list to watch over time
# Examines a list of PIDs because how do you know which is the problematic
one.
# Best copy the script to a directory by itself and run it from there
there.
# In directory where run from will create an individual file for each
process
# File titles are <PID>.info. At each interval will append one data line to
the file
# Results are best viewed using more *.info
# PROBLEM: Only tracks the top $1 PIDs at the point in time when script is
invoked.
# Recommend : setting this up in several directories and startup each
instance in a
# interval of time of your choice. You will now be able to track what is
happening with
# different list of PIDs in parallel with each list being a snapshot from
different
# invocation times.
ID_LIST=$(svmon -P -t $1 | grep -E " N | Y " | awk '{ print $1 }')
for PID in $ID_LIST ; do
# create individual files
echo "\n************************************************************" >
$PID.info
# list some relevant info
ps e $PID >> $PID.info
echo >> $PID.info
ps l $PID >> $PID.info
echo "----------------------------------------" >> $PID.info
# the line below is different for AIX 433 this is the AIX 5 version
echo " PID Vsid Esid Type Description LPage
Inuse Pin Pgsp Virtual"
>> $PID.info
done
let CNT=$3
while (( $CNT>0 ))
do
for PID in $ID_LIST ; do
echo "# $PID \c" >> $PID.info
# the # at line beginning is tag used for grep ^# etc
# record the listing for individual processes recording the "private
process" row
svmon -P $PID | grep process >> $PID.info
done
sleep $2
let CNT=$CNT-1
# echo $CNT
# uncomment above if want to some feedback
done
# Script end
An individual PID result will look like:
************************************************************
PID TTY STAT TIME COMMAND
1310738 - A 0:00 ora_smon_ptdemo
_=/u000/app/oracle/product/9.2.0.2/b
F S UID PID PPID C PRI NI ADDR SZ RSS WCHAN TTY
TIME CMD
240001 A 101 1310738 1 0 64 22 20074c38 53476 23188 -
0:00
----------------------------------------
PID Vsid Esid Type Description LPage Inuse
Pin Pgsp Virtual
# 1310738 74c38 f00000002 work process private - 13
7 1 14
Regards
Jim McDonald
__________________________________________________
Internal mail use: James McDonald
CSC
L1,15 Help St, Chatswood
Ph: 9464-4743 Email: jmcdon23@csc.com.au
----------------------------------------------------------------------------------------
This email, including any attachments, is intended only for use by the
addressee(s) and may contain confidential and/or personal information and
may also be the subject of legal privilege. Any personal information
contained in this email is not to be used or disclosed for any purpose
other than the purpose for which you have received it. If you are not the
intended recipient, you must not disclose or use the information contained
in it. In this case, please let me know by return email, delete the message
permanently from your system and destroy any copies.
----------------------------------------------------------------------------------------
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:42 EDT