Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Spool Usage of a user
 
From:   JAMES PARK

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016