Archives of the TeradataForum

Message Posted: Wed, 08 Dec 2004 @ 18:41:45 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, December 08, 2004 13:14 -->

You can check the user that is running the query (if they are only running 1 query)

     SELECT DataBaseName
           ,VPROC
           ,SUM(CurrentPerm)  AS CurrentPerm
           ,SUM(CURRENTSPOOL) as CURRENTSPOOL
           ,SUM(MaxSpool)     AS MaxSpool
           ,SUM(PeakSpool)    AS PeakSpool
       FROM Dbc.DiskSpace
      WHERE DataBaseName = 'YOURUSERNAME'
      GROUP BY 1,2
      ORDER BY 1,2

	<Prev	Next>		<<First	<Prev	Next>	Last>>