Archives of the TeradataForum
Message Posted: Thu, 06 May 2004 @ 19:16:14 GMT
| Subj: | | Re: Spool Usage without Session |
| |
| From: | | Coffing Christopher L |
This could be in part with a rollback situation.
The user may have lost their connection or the insert/update query failed and the users was disconnected somehow... The system would continue
to use the spool allocated for the rollback process.
If you run the SQL that you have below again and again you will more than likely see the spool decrease.
Best Regards
Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master
| 
