 |
 |
Archives of the TeradataForum
Message Posted: Mon, 25 Feb 2002 @ 19:22:33 GMT
| Subj: | | Re: Spool Space and Skewedness |
| |
| From: | | Geoffrey Rommel |
| | Hi, How does adding more spool space to one's account skew the data distribution on the system? | |
It doesn't. The spool space assigned to each user is not physically allocated; it is simply a number in the data dictionary. When
the user runs a query, the spool space total is divided by the number of AMPs; if the quotient is exceeded on any one AMP, the user is out
of spool.
If a user's spool space is increased, queries that used to fail with "out of spool" messages may run, or they may fail after a longer
time. This could cause more contention with other sessions for physical disk space. As long as the spool limits are reasonable, however,
you won't see much of a change.
| | What's the min and max limit? | |
Min = 0
Max = spool space allocated to the owner of that user. For instance, if DBA1 creates user USER1 under owner BUNCHOFUSERS, USER1 cannot have
a greater spool allocation than BUNCHOFUSERS does.
| |
