查看alert.log日志,发现有如下错误:
Sun Jun 1 23:07:32 2008
ARC1: Completed archiving log 4 thread 1 sequence 97333
Sun Jun 1 23:17:06 2008
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP1
Sun Jun 1 23:27:27 2008
Completed checkpoint up to RBA [0x17c36.2.10], SCN: 0x0001.8dbc38d1
Mon Jun 2 01:00:07 2008
Beginning log switch checkpoint up to RBA [0x17c37.2.10], SCN: 0x0001.8dc32665
Thread 1 advanced to log sequence 97335
Current log# 5 seq# 97335 mem# 0: /u/ORADB/data/log05a.dbf
Current log# 5 seq# 97335 mem# 1: /u/ORADB/data1/log05b.dbf
打电话报修,顾问建议我如下步骤:
1.select TABLESPACE_NAME,FILE_ID,FILE_NAME,AUTOEXTENSIBLE
FROM dba_temp_files
结果显示AUTOEXTENSIBLE=NO
2.顾问建议手动去加大TEMP空间.
Sun Jun 1 23:07:32 2008
ARC1: Completed archiving log 4 thread 1 sequence 97333
Sun Jun 1 23:17:06 2008
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP1
Sun Jun 1 23:27:27 2008
Completed checkpoint up to RBA [0x17c36.2.10], SCN: 0x0001.8dbc38d1
Mon Jun 2 01:00:07 2008
Beginning log switch checkpoint up to RBA [0x17c37.2.10], SCN: 0x0001.8dc32665
Thread 1 advanced to log sequence 97335
Current log# 5 seq# 97335 mem# 0: /u/ORADB/data/log05a.dbf
Current log# 5 seq# 97335 mem# 1: /u/ORADB/data1/log05b.dbf
打电话报修,顾问建议我如下步骤:
1.select TABLESPACE_NAME,FILE_ID,FILE_NAME,AUTOEXTENSIBLE
FROM dba_temp_files
结果显示AUTOEXTENSIBLE=NO
2.顾问建议手动去加大TEMP空间.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14132743/viewspace-329557/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
