|
|
Archives of the TeradataForum
Message Posted: Thu, 10 Jan 2013 @ 22:26:33 GMT
Subj: | | Spool Usage of a user |
|
From: | | Bakthavachalam, Roopalini |
Hi Forum,
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;
Thanks
Roopalini
| |