database 数据库中没有更多的假脱机空间
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/12479691/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
no more spool space in Database
提问by user1601052
I am using Teradata. In that I am getting 'no more spool space in Database'. My database utilization is 85%. Is there any relationship between this error and DB utilization factor ? Any studies on this would be more helpful for me to resolve this. Share me your ideas to avoid this.
我正在使用 Teradata。因为我得到了“数据库中没有更多的假脱机空间”。我的数据库利用率是 85%。这个错误和数据库利用率之间有什么关系吗？对此的任何研究都会对我解决这个问题更有帮助。与我分享您的想法以避免这种情况。
回答by BellevueBob
Spool spaceproblems occur either when you have an inefficient query or when statisticshave not been properly collected on the tables you are using. It can also happen with tables where the primary index was poorly chosen (high skew). Spool is an attribute of the user account you are using to connect to the Teradata environment; it is not really an attribute of the database itself.
Spool space当您的查询效率低下或statistics没有在您使用的表上正确收集时，就会出现问题。主索引选择不当（高偏斜）的表也可能发生这种情况。Spool 是您用来连接 Teradata 环境的用户帐户的一个属性；它并不是数据库本身的真正属性。
The only way to know for certain is to look at the EXPLAINplan for your query.
确定的唯一方法是查看EXPLAIN查询计划。
If your query is inefficient, rewrite it. If statistics need to be collected or if the index needs to be altered, contact the DBA responsible for the tables you are using.
如果您的查询效率低下，请重写它。如果需要收集统计信息或需要更改索引，请联系负责您正在使用的表的 DBA。
If there is a particular query that is giving you an "out of spool" error, update this question with the complete text of the query.
如果有一个特定的查询给您一个“out of spool”错误，用查询的完整文本更新这个问题。
回答by JT Lehman
I was not able to resolve my "out of spool" error by the methods above. I resolved the error by moving a rank function into its own small table without any join or extraneous columns.
我无法通过上述方法解决我的“假脱机”错误。我通过将 rank 函数移动到它自己的小表中来解决这个错误，没有任何连接或无关的列。
回答by Veda Chaithanya Deepika
Spool space can occur when you use tables having large data. If you are using multiple tables, check if you are using alias names instead of referring the complete table. Using alias names actually narrows down the data by the joins. Also see if functions like oreplace which consume more data are being used. Try using regular expressions in that case.
当您使用具有大量数据的表时，可能会出现假脱机空间。如果您使用多个表，请检查您是否使用别名而不是引用完整的表。使用别名实际上通过连接缩小了数据的范围。还要查看是否正在使用像 oreplace 这样消耗更多数据的函数。在这种情况下尝试使用正则表达式。
