|
************************************************************************
[DB-S:/]# uname -a
SunOS DB-S 5.9 Generic_117171-07 sun4us sparc FJSV,GPUZC-M
[DB-S:/]# su - oracle
[DB-S:/oracle]# sqlplus '/as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Aug 2 09:52:15
2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights
reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit
Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL>
************************************************************************
지금 문의드리고자 하는 시스템 사항은 위와 같습니다.
그런데 alert.log 에 아래와 같이 무지막지하게 마구 출력되는
경우가
너무 빈번합니다.
어떤분께서 temp 테이블 스페이스를 늘리면 된다고 했는데요.
처음 500MB 에서 지금은 거의 2GB 를 넘어가고 있습니다.
그것이 근본적인 해결책이 아닌것 같은데 어찌해야 할지
말씀부탁드립니다.
감사합니다.
************************************************************************
[DB-S : /oracle/product/9201/admin/bdump]# cat alert.log
Mon Jul 24 06:51:07 2006
Thread 1 advanced to log sequence 1846
Current log# 1 seq# 1846 mem# 0: /oradata3/redo01.log
Mon Jul 24 13:51:06 2006
Thread 1 advanced to log sequence 1847
Current log# 2 seq# 1847 mem# 0: /oradata3/redo02.log
Mon Jul 24 15:27:35 2006
Created Undo Segment _SYSSMU11$
Undo Segment 11 Onlined
Mon Jul 24 15:27:35 2006
Created Undo Segment _SYSSMU12$
Undo Segment 12 Onlined
Mon Jul 24 19:02:27 2006
SMON offlining US=11
SMON offlining US=12
Mon Jul 24 19:37:35 2006
Thread 1 advanced to log sequence 1848
Current log# 3 seq# 1848 mem# 0: /oradata3/redo03.log
Mon Jul 24 19:39:46 2006
Undo Segment 11 Onlined
Mon Jul 24 19:41:13 2006
Undo Segment 12 Onlined
Mon Jul 24 19:41:13 2006
Created Undo Segment _SYSSMU13$
Undo Segment 13 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU14$
Mon Jul 24 19:44:02 2006
Undo Segment 14 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU15$
Mon Jul 24 19:44:02 2006
Undo Segment 15 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU16$
Mon Jul 24 19:44:02 2006
Undo Segment 16 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU17$
Undo Segment 17 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU18$
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU19$
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU20$
Mon Jul 24 19:44:02 2006
Undo Segment 18 Onlined
Mon Jul 24 19:44:02 2006
Undo Segment 19 Onlined
Mon Jul 24 19:44:02 2006
Undo Segment 20 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU21$
Mon Jul 24 19:44:02 2006
Undo Segment 21 Onlined
Mon Jul 24 19:44:02 2006
Created Undo Segment _SYSSMU22$
Undo Segment 22 Onlined
Mon Jul 24 19:44:03 2006
Created Undo Segment _SYSSMU23$
Undo Segment 23 Onlined
Mon Jul 24 19:56:48 2006
Thread 1 advanced to log sequence 1849
Current log# 1 seq# 1849 mem# 0: /oradata3/redo01.log
Mon Jul 24 20:15:44 2006
Thread 1 advanced to log sequence 1850
Current log# 2 seq# 1850 mem# 0: /oradata3/redo02.log
Mon Jul 24 20:38:53 2006
Thread 1 advanced to log sequence 1851
Current log# 3 seq# 1851 mem# 0: /oradata3/redo03.log
Mon Jul 24 21:01:42 2006
Thread 1 advanced to log sequence 1852
Current log# 1 seq# 1852 mem# 0: /oradata3/redo01.log
Mon Jul 24 21:24:18 2006
Thread 1 advanced to log sequence 1853
Current log# 2 seq# 1853 mem# 0: /oradata3/redo02.log
Tue Jul 25 07:06:42 2006
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
SMON offlining US=20
SMON offlining US=21
SMON offlining US=22
SMON offlining US=23
Tue Jul 25 08:37:55 2006
Thread 1 advanced to log sequence 1854
Current log# 3 seq# 1854 mem# 0: /oradata3/redo03.log
Tue Jul 25 08:50:30 2006
Undo Segment 11 Onlined
Tue Jul 25 08:50:31 2006
Undo Segment 12 Onlined
Tue Jul 25 08:50:31 2006
Undo Segment 13 Onlined
Tue Jul 25 08:50:31 2006
Undo Segment 14 Onlined
Tue Jul 25 08:50:31 2006
Undo Segment 15 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 16 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 17 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 18 Onlined
Undo Segment 19 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 20 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 21 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 22 Onlined
Tue Jul 25 08:51:53 2006
Undo Segment 23 Onlined
Tue Jul 25 08:51:53 2006
Created Undo Segment _SYSSMU24$
Tue Jul 25 08:51:53 2006
Undo Segment 24 Onlined
Tue Jul 25 08:51:53 2006
Created Undo Segment _SYSSMU25$
Undo Segment 25 Onlined
Tue Jul 25 08:51:53 2006
Created Undo Segment _SYSSMU26$
Undo Segment 26 Onlined
Tue Jul 25 08:51:53 2006
Created Undo Segment _SYSSMU27$
Tue Jul 25 08:51:53 2006
Undo Segment 27 Onlined
Tue Jul 25 08:51:53 2006
Created Undo Segment _SYSSMU28$
Undo Segment 28 Onlined
Tue Jul 25 08:51:53 2006
Created Undo Segment _SYSSMU29$
Undo Segment 29 Onlined
Tue Jul 25 08:54:49 2006
Created Undo Segment _SYSSMU30$
Undo Segment 30 Onlined
Tue Jul 25 08:54:50 2006
Created Undo Segment _SYSSMU31$
Undo Segment 31 Onlined
Tue Jul 25 08:56:20 2006
Created Undo Segment _SYSSMU32$
Undo Segment 32 Onlined
Tue Jul 25 08:59:56 2006
Created Undo Segment _SYSSMU33$
Tue Jul 25 08:59:56 2006
Undo Segment 33 Onlined
Tue Jul 25 08:59:56 2006
Created Undo Segment _SYSSMU34$
Undo Segment 34 Onlined
Tue Jul 25 08:59:56 2006
Created Undo Segment _SYSSMU35$
Undo Segment 35 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU36$
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU37$
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU38$
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU39$
Tue Jul 25 08:59:57 2006
Undo Segment 36 Onlined
Tue Jul 25 08:59:57 2006
Undo Segment 37 Onlined
Tue Jul 25 08:59:57 2006
Undo Segment 39 Onlined
Tue Jul 25 08:59:57 2006
Undo Segment 38 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU40$
Tue Jul 25 08:59:57 2006
Undo Segment 40 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU41$
Undo Segment 41 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU42$
Undo Segment 42 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU43$
Undo Segment 43 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU44$
Undo Segment 44 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU45$
Undo Segment 45 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU46$
Undo Segment 46 Onlined
Tue Jul 25 08:59:57 2006
Created Undo Segment _SYSSMU47$
Undo Segment 47 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU48$
Undo Segment 48 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU49$
Undo Segment 49 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU50$
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU51$
Tue Jul 25 09:08:07 2006
Undo Segment 50 Onlined
Tue Jul 25 09:08:07 2006
Undo Segment 51 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU52$
Undo Segment 52 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU53$
Undo Segment 53 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU54$
Tue Jul 25 09:08:07 2006
Undo Segment 54 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU55$
Tue Jul 25 09:08:07 2006
Undo Segment 55 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU56$
Undo Segment 56 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU57$
Undo Segment 57 Onlined
Tue Jul 25 09:08:07 2006
Created Undo Segment _SYSSMU58$
Undo Segment 58 Onlined
Tue Jul 25 11:04:52 2006
Thread 1 advanced to log sequence 1855
Current log# 1 seq# 1855 mem# 0: /oradata3/redo01.log
Tue Jul 25 19:10:26 2006
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
SMON offlining US=16
SMON offlining US=17
SMON offlining US=18
SMON offlining US=19
SMON offlining US=20
SMON offlining US=21
SMON offlining US=22
SMON offlining US=23
SMON offlining US=24
SMON offlining US=25
SMON offlining US=26
SMON offlining US=27
SMON offlining US=28
SMON offlining US=29
SMON offlining US=30
SMON offlining US=31
SMON offlining US=32
SMON offlining US=33
SMON offlining US=34
SMON offlining US=35
SMON offlining US=36
SMON offlining US=37
SMON offlining US=38
SMON offlining US=39
SMON offlining US=40
SMON offlining US=41
SMON offlining US=42
SMON offlining US=43
SMON offlining US=44
SMON offlining US=45
SMON offlining US=46
SMON offlining US=47
SMON offlining US=48
SMON offlining US=49
SMON offlining US=50
SMON offlining US=51
SMON offlining US=52
SMON offlining US=53
SMON offlining US=54
SMON offlining US=55
SMON offlining US=56
SMON offlining US=57
SMON offlining US=58
Tue Jul 25 21:18:22 2006
Thread 1 advanced to log sequence 1856
Current log# 2 seq# 1856 mem# 0: /oradata3/redo02.log
Wed Jul 26 15:15:31 2006
Thread 1 advanced to log sequence 1857
Current log# 3 seq# 1857 mem# 0: /oradata3/redo03.log
Wed Jul 26 16:03:14 2006
Created Undo Segment _SYSSMU11$
Wed Jul 26 16:03:14 2006
Undo Segment 11 Onlined
Wed Jul 26 16:03:14 2006
Created Undo Segment _SYSSMU12$
Wed Jul 26 16:03:14 2006
Undo Segment 12 Onlined
Wed Jul 26 16:03:14 2006
Created Undo Segment _SYSSMU13$
Undo Segment 13 Onlined
Wed Jul 26 16:03:14 2006
Created Undo Segment _SYSSMU14$
Undo Segment 14 Onlined
Wed Jul 26 16:03:14 2006
Created Undo Segment _SYSSMU15$
Undo Segment 15 Onlined
Wed Jul 26 19:13:46 2006
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
Thu Jul 27 09:35:48 2006
Thread 1 advanced to log sequence 1858
Current log# 1 seq# 1858 mem# 0: /oradata3/redo01.log
Thu Jul 27 17:26:38 2006
************************************************************************
|
