Re: Q:How to find list user sessions with database

You could also use onstat -g sql instead of onstat -g ses <sessid>. Steve Berg spb@nb.com On Wed, 15 Jul 1998, CONWAY Graham wrote: > Hi, > > Please excuse me if this is obvious. > > Does anyone have a simple way (sysmaster query or onstat option) of listing > the sessions on a server and the database they are currently connected to. > > I have a script that does it by going through the onstat -u output and > calling onstat -g sess <sessid> for each session, but there must be a > quicker way. > > Thanks, > > Graham Conway > OAMI Alicante >