Re: matching sessions with databases

If you do an onstat -g sql, there is a column that tells you which database each session is connected to. So you could do an "onstat -g sql | grep <db>" to see which sessions are accessing a particular database. Sean Gilmour wrote in message <3655FF8E.AC274878@css.mot.com>... >Hi Nicole, > If you run a onstat -g ses # of the session id at the bottom it will >tell you the current database for that session id. > >Nicole Guffey wrote: > >> Is there a utility, or a piece of code, that identifies which >> database (or even dbspace) a session is accessing? >> >> Thank You, >> Nicole Guffey >> Nguffey@jdriscoll.com > > >