Re: Total memory & used memory in onstat -g ses

Look in syspools. You'll need to do a little math to exactly reproduce the onstat -g ses info., but everything you need is there. syssessions has char(16) for the hostname, but if you are on an HP system, HP-UX uses only 8 character hostnames. Good luck, Arun Bernstein, Rick wrote: > The onstat -g ses commands displays total memory and used memory by > session. Does anyone know how I can reproduce this display using > sysmaster tables? > > I am trying to determine which host(s) are initiating sessions using larger > amounts of memory. This onstat command shows only the first 8 characters > of the host name. Unfortunately, all of our SAP application servers use the > > same first 8 characters in their host name, and our management is > unwilling to change this naming convention. > > Your assistance in finding another way to display this information > would be appreciated. > > Rick Bernstein Phone: (619) 458-7048 > Principal Database Administrator FAX: (619) 458-7640 > Alaris Medical Systems E-mail: rbernste@alarismed.com > San Diego, CA 92121