oracle9204undo空间无限增长

vl_sky

oracle9204undo空间无限增长，已达20多G

这是怎么回事？

以下是部分日志
Mon Apr 14 14:32:09 2008
ORA-1652: unable to extend temp segment by 128 in tablespace                 SPCC_TEMP
Mon Apr 14 14:34:18 2008
ORA-1652: unable to extend temp segment by 128 in tablespace                 SPCC_TEMP
Mon Apr 14 14:36:24 2008
ORA-1652: unable to extend temp segment by 128 in tablespace                 SPCC_TEMP
Mon Apr 14 14:42:01 2008
/* OracleOEM */ ALTER DATABASE TEMPFILE '/opt/ora9/oradata/orcl/SPCC_TEMP.dbf' RESIZE  700M
Mon Apr 14 14:42:01 2008
Completed: /* OracleOEM */ ALTER DATABASE TEMPFILE '/opt/ora9
Mon Apr 14 14:49:57 2008
ORA-1652: unable to extend temp segment by 128 in tablespace                 LECC_TEMP
Mon Apr 14 15:26:30 2008
Thread 1 advanced to log sequence 3588
  Current log# 8 seq# 3588 mem# 0: /opt/ora9/oradata/orcl/logORCL8.ora
Mon Apr 14 22:07:29 2008
Thread 1 advanced to log sequence 3589
  Current log# 9 seq# 3589 mem# 0: /opt/ora9/oradata/orcl/logORCL9.ora
Tue Apr 15 08:35:52 2008
Thread 1 advanced to log sequence 3590
  Current log# 10 seq# 3590 mem# 0: /opt/ora9/oradata/orcl/logORCL10.ora
Tue Apr 15 13:47:58 2008
Thread 1 advanced to log sequence 3591
  Current log# 1 seq# 3591 mem# 0: /opt/ora9/oradata/orcl/redo01.log
Tue Apr 15 13:54:45 2008
Thread 1 advanced to log sequence 3592
  Current log# 2 seq# 3592 mem# 0: /opt/ora9/oradata/orcl/redo02.log
Tue Apr 15 17:27:28 2008
Thread 1 advanced to log sequence 3593
  Current log# 3 seq# 3593 mem# 0: /opt/ora9/oradata/orcl/redo03.log
Wed Apr 16 00:42:33 2008
Thread 1 advanced to log sequence 3594
  Current log# 4 seq# 3594 mem# 0: /opt/ora9/oradata/orcl/logORCL4.ora
Wed Apr 16 10:07:50 2008
Thread 1 advanced to log sequence 3595
  Current log# 5 seq# 3595 mem# 0: /opt/ora9/oradata/orcl/logORCL5.ora
Wed Apr 16 13:34:49 2008
Errors in file /opt/ora9/admin/orcl/udump/orcl_ora_20095.trc:
ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], []
Wed Apr 16 16:42:00 2008
Thread 1 advanced to log sequence 3596
  Current log# 6 seq# 3596 mem# 0: /opt/ora9/oradata/orcl/logORCL6.ora
Wed Apr 16 23:04:37 2008
Thread 1 advanced to log sequence 3597
  Current log# 7 seq# 3597 mem# 0: /opt/ora9/oradata/orcl/logORCL7.ora
Thu Apr 17 08:42:38 2008
Thread 1 advanced to log sequence 3598
  Current log# 8 seq# 3598 mem# 0: /opt/ora9/oradata/orcl/logORCL8.ora
Thu Apr 17 13:59:18 2008
Thread 1 advanced to log sequence 3599
  Current log# 9 seq# 3599 mem# 0: /opt/ora9/oradata/orcl/logORCL9.ora
Thu Apr 17 19:58:45 2008
Thread 1 advanced to log sequence 3600
  Current log# 10 seq# 3600 mem# 0: /opt/ora9/oradata/orcl/logORCL10.ora
Fri Apr 18 05:26:37 2008
Thread 1 advanced to log sequence 3601
  Current log# 1 seq# 3601 mem# 0: /opt/ora9/oradata/orcl/redo01.log
Fri Apr 18 12:37:44 2008
Thread 1 advanced to log sequence 3602
  Current log# 2 seq# 3602 mem# 0: /opt/ora9/oradata/orcl/redo02.log
Fri Apr 18 14:25:45 2008
ORA-1652: unable to extend temp segment by 128 in tablespace                 LECC_TEMP
Fri Apr 18 14:26:45 2008
ORA-1652: unable to extend temp segment by 128 in tablespace                 LECC_TEMP
Fri Apr 18 19:41:20 2008
Thread 1 advanced to log sequence 3603
  Current log# 3 seq# 3603 mem# 0: /opt/ora9/oradata/orcl/redo03.log
Sat Apr 19 01:47:00 2008
Thread 1 advanced to log sequence 3604
  Current log# 4 seq# 3604 mem# 0: /opt/ora9/oradata/orcl/logORCL4.ora
Sat Apr 19 10:51:15 2008
Thread 1 advanced to log sequence 3605
  Current log# 5 seq# 3605 mem# 0: /opt/ora9/oradata/orcl/logORCL5.ora
Sat Apr 19 17:10:47 2008
Thread 1 advanced to log sequence 3606
  Current log# 6 seq# 3606 mem# 0: /opt/ora9/oradata/orcl/logORCL6.ora
Sun Apr 20 01:14:20 2008
Thread 1 advanced to log sequence 3607
  Current log# 7 seq# 3607 mem# 0: /opt/ora9/oradata/orcl/logORCL7.ora
Sun Apr 20 10:47:52 2008
Thread 1 advanced to log sequence 3608
  Current log# 8 seq# 3608 mem# 0: /opt/ora9/oradata/orcl/logORCL8.ora
Sun Apr 20 18:30:40 2008
Thread 1 advanced to log sequence 3609
  Current log# 9 seq# 3609 mem# 0: /opt/ora9/oradata/orcl/logORCL9.ora
Mon Apr 21 03:38:17 2008
Thread 1 advanced to log sequence 3610
  Current log# 10 seq# 3610 mem# 0: /opt/ora9/oradata/orcl/logORCL10.ora
Mon Apr 21 09:34:01 2008
/* OracleOEM */ ALTER DATABASE TEMPFILE '/opt/ora9/oradata/orcl/LECC_TEMP.dbf' RESIZE  800M
Mon Apr 21 09:34:02 2008
Completed: /* OracleOEM */ ALTER DATABASE TEMPFILE '/opt/ora9
Mon Apr 21 10:38:15 2008
Thread 1 advanced to log sequence 3611
  Current log# 1 seq# 3611 mem# 0: /opt/ora9/oradata/orcl/redo01.log
Mon Apr 21 15:59:26 2008
Thread 1 advanced to log sequence 3612
  Current log# 2 seq# 3612 mem# 0: /opt/ora9/oradata/orcl/redo02.log
Mon Apr 21 21:50:29 2008
Thread 1 advanced to log sequence 3613
  Current log# 3 seq# 3613 mem# 0: /opt/ora9/oradata/orcl/redo03.log
Tue Apr 22 06:55:26 2008
Thread 1 advanced to log sequence 3614
  Current log# 4 seq# 3614 mem# 0: /opt/ora9/oradata/orcl/logORCL4.ora
Tue Apr 22 13:36:20 2008
Thread 1 advanced to log sequence 3615
  Current log# 5 seq# 3615 mem# 0: /opt/ora9/oradata/orcl/logORCL5.ora
Tue Apr 22 15:44:35 2008
Errors in file /opt/ora9/admin/orcl/udump/orcl_ora_2403.trc:
ORA-00600: internal error code, arguments: [729], [100], [space leak], [], [], [], [], []
ORA-02068: following severe error from JGCC.DB
ORA-03113: end-of-file on communication channel
Tue Apr 22 19:56:23 2008
Thread 1 advanced to log sequence 3616
  Current log# 6 seq# 3616 mem# 0: /opt/ora9/oradata/orcl/logORCL6.ora
Wed Apr 23 05:09:29 2008
Thread 1 advanced to log sequence 3617
  Current log# 7 seq# 3617 mem# 0: /opt/ora9/oradata/orcl/logORCL7.ora
Wed Apr 23 12:11:56 2008
Thread 1 advanced to log sequence 3618
  Current log# 8 seq# 3618 mem# 0: /opt/ora9/oradata/orcl/logORCL8.ora
Wed Apr 23 17:43:39 2008
Thread 1 advanced to log sequence 3619
  Current log# 9 seq# 3619 mem# 0: /opt/ora9/oradata/orcl/logORCL9.ora
Thu Apr 24 03:14:09 2008
Thread 1 advanced to log sequence 3620
  Current log# 10 seq# 3620 mem# 0: /opt/ora9/oradata/orcl/logORCL10.ora
Thu Apr 24 11:19:36 2008
Thread 1 advanced to log sequence 3621
  Current log# 1 seq# 3621 mem# 0: /opt/ora9/oradata/orcl/redo01.log
Thu Apr 24 18:05:28 2008
Thread 1 advanced to log sequence 3622
  Current log# 2 seq# 3622 mem# 0: /opt/ora9/oradata/orcl/redo02.log
Fri Apr 25 02:34:57 2008
Thread 1 advanced to log sequence 3623
  Current log# 3 seq# 3623 mem# 0: /opt/ora9/oradata/orcl/redo03.log

vl_sky

各位大仙，支持一哈
问题很严重啊

Chinese_Dragon

I can't anything about the UNDO in your log

flutter

重启一下看能否释放，日志里好象有临时表空间无法扩展的信息，600错误很严重，有服务的话联系一下ORALCE。

    我碰到过一次类似，应用程序写的有问题，没有释放，导致TEMP临时表空间撑爆了空间，数据库停止响应。

stone_jinhao

看看$sessions，是否有大量的未释放的连接