Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 06 May 2004 @ 19:16:14 GMT


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


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019