All Forums Database
Amit Kumar 14 posts Joined 08/11
03 Oct 2011
What is Spool Space? Why do you get spool space errors? How do trouble-shoot them?

hi all i want to know something about spool space and it's error.

Adeel Chaudhry 773 posts Joined 04/08
11 Oct 2011

Hi,

 

Spool space is an intermediate dataset storage space. Usually spool space errors occur due to stale stats resulting in product joins. To troubleshoot them, fix the query which is causing them and increase the system/user spool space if you can.

 

For further details, please research on "Spool space of databases" on search engine you prefer the most.

 

Regards, MAC

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.