no more spool space in Database

user1601052 picture user1601052 · Sep 18, 2012 · Viewed 84.6k times · Source

I am using Teradata. In that I am getting 'no more spool space in Database'. My database utilization is 85%. Is there any relationship between this error and DB utilization factor ? Any studies on this would be more helpful for me to resolve this. Share me your ideas to avoid this.

Answer

BellevueBob picture BellevueBob · Sep 18, 2012

Spool space problems occur either when you have an inefficient query or when statistics have not been properly collected on the tables you are using. It can also happen with tables where the primary index was poorly chosen (high skew). Spool is an attribute of the user account you are using to connect to the Teradata environment; it is not really an attribute of the database itself.

The only way to know for certain is to look at the EXPLAIN plan for your query.

If your query is inefficient, rewrite it. If statistics need to be collected or if the index needs to be altered, contact the DBA responsible for the tables you are using.

If there is a particular query that is giving you an "out of spool" error, update this question with the complete text of the query.