Archives of the TeradataForum

Message Posted: Fri, 11 Jan 2013 @ 13:51:03 GMT

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

Good morning,

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.

James Park
Database Specialist II

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