Total memory & used memory in onstat -g ses

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