Archives of the TeradataForum
Message Posted: Fri, 11 Jan 2013 @ 13:51:03 GMT
This is a similar situation.
A user in PRD got an error while running a query. The error said, "There is no more spool space."
His spool space in the profile showed he had 200G.
I increased it to 400G and haven't heard from him since. My questions are,
1. Other users have 200G of spool space assigned. What impact might this increase for one user have on others? What happens if two users run a query that uses 300G of spool space each at the same time?
2. Spool Reserve has 500G assigned in this system. But the spool space for SYSDBA and All_Users is 1000G. Is this possible? I think that 500G for Spool Reserve is perm space and the spool space for SYSDBA and All_Users is not perm space.
Thank you in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|