Archives of the TeradataForum
Message Posted: Thu, 13 Sep 2001 @ 20:37:04 GMT
This method assumes no spool = inactive, but you could take a count of distinct users having SUM(CURRENTSPOOL) > 0 from DBC.Diskspace. This will not capture utility sessions (MLoad, Fastload) from what I recall but would get you anyone running Selects or Exports at the time.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|