“ORA-1652: unable to extend temp…
来源:互联网 发布:优学院软件下载 编辑:程序博客网 时间:2024/05/16 08:43
“ORA-1652: unable toextend temp segment”
Oracle排序的基础
识别由于缺少临时表空间失败的SQL语句
ALTER SYSTEM RESET EVENT SCOPE = SPFILE SID = '*';
ALTER SYSTEM SET EVENTS '1652 trace name context off';
ALTER SESSION SET EVENTS'1652 trace name context off';
如果一个SQL语句由于缺少临时表空间失败并且ORA-1652诊断事件已经激活,那么
Oracle服务器进程将会在遇到错误时在user_dump_dest目录的跟踪文件写入错误信息,并且警告日志会指示出相关跟踪文件。如:
Tue Jan
Errors in file
/u01/app/oracle/admin/rpkprod/udump/rpkprod_ora_10847.trc:ORA-01652: unable to extend temp segment by 128 in tablespaceTEMP
Oracle Database 10gRelease 10.2.0.2.0 - 64bit Production
ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_2
Systemname:
Nodename:
Release:
Version:
Machine:
Instance name:rpkprod
Redo thread mountedby this instance: 1
Oracle processnumber: 18
Unix process pid:10847, image: oracle@rpk (TNS V1-V3)
*** ACTION NAME:()2007-01-02 17:21:14.871
*** MODULENAME:(SQL*Plus) 2007-01-02 17:21:14.871
*** SERVICENAME:(SYS$USERS) 2007-01-02 17:21:14.871
*** SESSIONID:(130.13512) 2007-01-02 17:21:14.871
*** 2007-01-0217:21:14.871
ksedmp: internal orfatal error
ORA-01652: unable toextend temp segment by 128 in tablespace TEMP
Current SQLstatement for this session:
SELECT
E","A1"."CUSTOMER_ID", "A1"."CUSTOMER_NAME","A1"."INVOICE_AMOUNT",
M_COUNT","A1"."PAYMENTS_TOTAL"
FROM
ORDER BY"A1"."CUSTOMER_NAME", "A1"."INVOICE_NUMBER"
----- Call Stack Trace-----
虽然使用这种方法可以得到相当详细的信息,但是需要注意的是,这种方法捕获到的语
句并不一定是问题的根源,因为有可能前一个语句消耗了99.9%临时空间,而第二个语句被捕获到跟踪文件中。
监控临时表空间
临时段
SELECT A.tablespace_name tablespace,
会话使用的排序空间
SELECT S.sid || ',' || S.serial# sid_serial,
语句使用的临时空间
SELECT S.sid || ',' || S.serial# sid_serial,
- “ORA-1652: unable to extend temp…
- ORA-1652: Unable To&nb…
- unable to create …
- RMAN备份错误ORA-01264: Unable to…
- ORA-01659: unable to&n…
- ORACLE ORA-01653: unable t…
- 解决:Unable to connec…
- Unable to install&nbsp…
- 1607:Unable to install InstallSh…
- Unable to resolve&nbsp…
- ios unable to deq…
- ORA-19909 datafile 1 belongs to …
- ORA-16014,接着 …
- Error: ORA-1505…
- ORA-03137: TTC …
- alter tablespace temp&…
- QTP录制时报错: unable to launch …
- Unable to chmod sdcard: Read-onl…
- Kill Session 后寻找该会话的SPID
- 在线购物网站-实验4
- 系统验证与SQLNET.AUTHENTICATION_…
- tomcat 输入localhost:8080显示404 (找不到tomcat主页)
- 使用split命令分割alter日志文件(…
- “ORA-1652: unable to extend temp…
- 使用外部表访问警告日志内容(转)
- 如何快速杀死占用过多资源(CPU,内…
- 飘逸的python
- 使用RMAN恢复一个表空间
- OkHttp入门
- ORA-01190
- 添加数据文件及修改数据文件的位置
- 设置还原表空间文件脱机故障