Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 17 Mar 2004 @ 21:19:07 GMT

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

Subj:   Re: Spool Space issues
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, March 17, 2004 16:04 -->

Fluctuations in spool issues can be caused by a variety of issues. Some culprits (by no means all of them):

No Stats causing a random amp sample. If your data is unevenly distributed, then the sample could differ resulting in a different explain plan.

Different queries asking for different data on the same report. The data can skew differently in this case causing the spool space issue.

Users executing multiple reports under the same ID. Your report that normally runs in 20 minutes might run for 3 hours, 10 minutes on a busy box. Then, at 3 hours into that report the user kicks off another query that consumes a lot of spool. The result, both queries spool out.

Increasing the system size without increasing your spool space can cause issues as well. You essentially have the same amount of spool space spread over more amps resulting in less spool per amp.

  <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