Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > ORA-01652，temp表空间不足的相关问题

ORA-01652，temp表空间不足的相关问题

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release： 2016-06-07 17:21:35
Original
1559 people have browsed it

登录数据库，查看主机日志，报错内容为ORA-01652，temp表空间不足ORA-01652: unable to extend temp segment by 128 in tablespa

十一长假期间也不得轻松，某日接到业务保障，数据库报错，导致某关键业务不能正常执行，需要立即处理

原因分析

1，登录数据库，查看主机日志，报错内容为ORA-01652，temp表空间不足

ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01

2，让业务部门重新执行相关脚本，发现占用temp表空间的具体语句如下，目前temp表空间96GB，，大约1个小时会被该sql使用满，sql异常退出

Sql具体如下 

执行计划如下

linux

Related labels：
o
source：php.cn
Previous article：Linux下新建Oracle数据库实例 Next article：有归档日志无基线备份的数据库恢复
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to solve the problem of "ORA-00922: missing or invalid option" error?
From 1970-01-01 08:00:00
0
0
0
Error Code: 907 Error Message: ORA-00907: missing closing bracket PHP Laravel (Eloquent Method)
From 1970-01-01 08:00:00
0
0
0
Passing PHP variables to SQL query in oci_parse
From 1970-01-01 08:00:00
0
0
0
How to solve the following problems
From 1970-01-01 08:00:00
0
0
0
Team collaboration - What should I do if someone needs the feature I wrote as a dependency in git flow?
From 1970-01-01 08:00:00
0
0
0
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template