######################################################################
# This program reads the result of onstat -g ses and merges it with a call
# to ps -p. The result is a list of database processes, and their corresponding
# UNIX process.
# Output includes the following columns:
#	sess-id,user,tty,pid,threads,mem alloc/used,s-time,elapsed-t,process
#
# Usage:
#	dbps [-p]
# Parameters:
#	-p	Appends parent process information.  To keep output to 80 cols,
#		mem alloc/used columns are dropped from output in this mode.
#		This output is handy when SQL is embedded in shell scripts
#		frequently, as they otherwise show up only as dbaccess sessions
# Limitations:
#	The Berkeley UNIX ps doesn't support passing multiple process ids as
#	arguments to -p, so in its current form this program can only run on
#	SysV Unix flavours, such as Solaris, OS/F etc.
#
# Suggested Usage:
#	If using -p option frequently, create the following alias
#	alias dbpp='dbps -p'
#
# Author:
#	Richard Thomas <ret@mac.com>
######################################################################