Archives of the TeradataForum
Message Posted: Thu, 10 Jan 2013 @ 22:26:33 GMT
A user in our system has been allocated 100Gb spool space through a profile. Today when I ran the below query to check the spool usage of the user , it shows SUM(PEAKSPOOL) = 800GB. Is that possible?
SELECT DATE, A.DATABASENAME, B.OWNERNAME, SUM(PEAKSPOOL) FROM DBC.DISKSPACE A, DBC.DBASE B WHERE A.DATABASENAME = B.DATABASENAME GROUP BY 1,2,3 HAVING SUM(PEAKSPOOL) > 0;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|