Home » RDBMS Server » Server Administration » Large trace files generated in udump (Oracle Database Enterprise Edition Release 10.2.0.4.0, AIX 5.3)
Large trace files generated in udump [message #528295] Mon, 24 October 2011 03:08 Go to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, guys
We have Oracle 10g(10.2.0.4) RAC on AIX 5.3, there are 3 RAC instances on each node.

From Oct 9th, we found one of the instance in node 1 generated a large size trace files in udump. The largest size of the trace file take up 3G. But there's only about 15G $ORACLE_BASE direcotry. After some time, we should delete some trace files for releasing the space.

Here is a part of alert log when this issue happen:
Sun Oct  9 23:18:15 2011
Errors in file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3166258.trc:
ORA-00600: internal error code, arguments: [17087], [0x70000010DF9F580], [], [], [], [], [], []
Sun Oct  9 23:18:16 2011
Trace dumping is performing id=[cdmp_20111009231816]
Sun Oct  9 23:33:17 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Sun Oct  9 23:48:18 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Sun Oct  9 23:49:30 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 00:00:18 2011
Thread 1 advanced to log sequence 4244 (LGWR switch)
  Current log# 6 seq# 4244 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_6.262.738307031
  Current log# 6 seq# 4244 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_6.262.738307031
Mon Oct 10 00:02:32 2011
Thread 1 advanced to log sequence 4245 (LGWR switch)
  Current log# 7 seq# 4245 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_7.263.738307033
  Current log# 7 seq# 4245 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_7.263.738307035
Mon Oct 10 00:03:19 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 00:05:13 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 00:18:51 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 00:20:57 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc

...

Mon Oct 10 00:49:05 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 00:52:25 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 01:04:37 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 01:08:10 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 01:19:49 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 01:23:56 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 01:34:52 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 01:39:41 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 01:50:25 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 01:55:26 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 02:00:21 2011
Thread 1 advanced to log sequence 4248 (LGWR switch)
  Current log# 5 seq# 4248 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_5.261.738307027
  Current log# 5 seq# 4248 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_5.261.738307029
Mon Oct 10 02:05:37 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 02:11:12 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 02:20:40 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 02:26:58 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 02:36:12 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 02:42:44 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 02:51:25 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 02:58:30 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 03:06:27 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 03:14:15 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 03:22:01 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 03:30:02 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 03:37:13 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 03:45:48 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 03:52:16 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 04:01:33 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 04:07:49 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 04:17:19 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 04:23:01 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 04:23:35 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 04:32:54 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 04:38:04 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 04:39:08 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 04:48:26 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 04:53:35 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 04:54:39 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 05:00:21 2011
Thread 1 advanced to log sequence 4249 (LGWR switch)
  Current log# 6 seq# 4249 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_6.262.738307031
  Current log# 6 seq# 4249 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_6.262.738307031
Mon Oct 10 05:03:43 2011
Thread 1 advanced to log sequence 4250 (LGWR switch)
  Current log# 7 seq# 4250 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_7.263.738307033
  Current log# 7 seq# 4250 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_7.263.738307035
Mon Oct 10 05:03:57 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 05:08:37 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 05:10:11 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 05:19:32 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 05:24:08 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3092524.trc
Mon Oct 10 05:25:44 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 05:35:04 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 05:39:11 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3445118.trc
Mon Oct 10 05:41:16 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3158172.trc
Mon Oct 10 05:50:37 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3104982.trc
Mon Oct 10 05:54:41 2011
System State dumped to trace filTue Oct 11 09:20:16 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 09:33:25 2011
Thread 1 advanced to log sequence 4286 (LGWR switch)
  Current log# 1 seq# 4286 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_1.257.738307021
  Current log# 1 seq# 4286 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_1.257.738307023
Tue Oct 11 09:35:51 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 09:51:25 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 10:06:57 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 10:13:49 2011
Thread 1 advanced to log sequence 4287 (LGWR switch)
  Current log# 2 seq# 4287 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_2.258.738307023
  Current log# 2 seq# 4287 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_2.258.738307025
Tue Oct 11 10:22:30 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 10:29:29 2011
Thread 1 advanced to log sequence 4288 (LGWR switch)
  Current log# 5 seq# 4288 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_5.261.738307027
  Current log# 5 seq# 4288 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_5.261.738307029
Tue Oct 11 10:38:02 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 10:53:34 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 11:02:46 2011
Thread 1 advanced to log sequence 4289 (LGWR switch)
  Current log# 6 seq# 4289 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_6.262.738307031
  Current log# 6 seq# 4289 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_6.262.738307031
Tue Oct 11 11:07:08 2011
Thread 1 advanced to log sequence 4290 (LGWR switch)
  Current log# 7 seq# 4290 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_7.263.738307033
  Current log# 7 seq# 4290 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_7.263.738307035
Tue Oct 11 11:09:06 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 11:24:39 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 11:40:13 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 11:55:45 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 12:01:26 2011
Thread 1 advanced to log sequence 4291 (LGWR switch)
  Current log# 1 seq# 4291 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_1.257.738307021
  Current log# 1 seq# 4291 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_1.257.738307023
Tue Oct 11 12:04:55 2011
Thread 1 advanced to log sequence 4292 (LGWR switch)
  Current log# 2 seq# 4292 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_2.258.738307023
  Current log# 2 seq# 4292 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_2.258.738307025
Tue Oct 11 12:06:42 2011
Thread 1 advanced to log sequence 4293 (LGWR switch)
  Current log# 5 seq# 4293 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_5.261.738307027
  Current log# 5 seq# 4293 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_5.261.738307029
Tue Oct 11 12:09:36 2011
Thread 1 advanced to log sequence 4294 (LGWR switch)
  Current log# 6 seq# 4294 mem# 0: +YW_DGSYSTEM/bzywk/onlinelog/group_6.262.738307031
  Current log# 6 seq# 4294 mem# 1: +YW_DGRECOVER/bzywk/onlinelog/group_6.262.738307031
Tue Oct 11 12:11:17 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 12:26:50 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 12:42:24 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 12:57:58 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 13:13:32 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc
Tue Oct 11 13:29:05 2011
System State dumped to trace file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_3424538.trc

...

Tue Oct 11 15:11:50 2011
Errors in file /oracle/app/oracle/admin/bzywk/udump/bzywk1_ora_2089118.trc:
ORA-00600: internal error code, arguments: [qctcfx : len], [0], [0], [], [], [], [], []
...


I checked with some trace files, I found all these files contains a huge info of processes.

I have no idea how to located the root cause.
Please kindly give me some advices.

Thanks very much,
Milo

Report message to a moderator

Re: Large trace files generated in udump [message #528300 is a reply to message #528295] Mon, 24 October 2011 03:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support
Have a look at alert.log and trace files.
You can also read this article: Troubleshooting Internal Errors.

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528304 is a reply to message #528300] Mon, 24 October 2011 03:44 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
Thanks for reply.
I have lookup those ora-600 errors on Metalink. But they don't say anything that those errors will generated such huge trace files, So I am not sure if this issue cause by ora-600.
Most of those files generated systemdump info.

Thanks very much,
Milo

Report message to a moderator

Re: Large trace files generated in udump [message #528306 is a reply to message #528304] Mon, 24 October 2011 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Have you any event set in your instance?

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528308 is a reply to message #528306] Mon, 24 October 2011 04:04 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
I don't set any event in the instance. And ask the developers, they said they don't set any events neither.

Thanks,

Report message to a moderator

Re: Large trace files generated in udump [message #528309 is a reply to message #528308] Mon, 24 October 2011 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Check again in alert.log, a system state dump can occur only on ORA-600, ORA-7445 and a couple of other errors or when it is requested by an event. As yours are not related to an error, then it should be related to an event.

If you find any then you have to open a SR.

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528314 is a reply to message #528309] Mon, 24 October 2011 04:35 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
Do you have any method to check if those events have been triggered?
I want to double check and make sure this.

Thanks very much,
Milo

Report message to a moderator

Re: Large trace files generated in udump [message #528320 is a reply to message #528314] Mon, 24 October 2011 05:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Connect as sysdba and execute:
oradebug setmypid
oradebug dump events 4

Post the generated trace file; it contains just after the header (that ends with "*** SESSION ID") a line "Dump event group for level SYSTEM".

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528327 is a reply to message #528320] Mon, 24 October 2011 05:19 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
I have tried this on my test environment, but it seems that there is no differences before I swtich on and after I switch on the event.

alter session set events 'immediate trace name SYSTEMSTATE level 10';



Here is what I am trying in my enviroment:
SYS@myrac2>oradebug setmypid
Statement processed.
SYS@myrac2>
SYS@myrac2>oradebug dump events 4 
Statement processed.
SYS@myrac2>alter session set events 'immediate trace name SYSTEMSTATE level 10';

Session altered.

SYS@myrac2>oradebug setmypid
Statement processed.
SYS@myrac2>oradebug dump events 4 
Statement processed.



Here is what I can see from the trace file:
*** 2011-10-24 18:08:57.608
Dump event group for level SYSTEM
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life
*** 2011-10-24 18:09:21.813
Dump event group for level SYSTEM
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life


Is there something I am missing？

Thanks very much,
Milo

[Updated on: Mon, 24 October 2011 05:20]

Report message to a moderator

Re: Large trace files generated in udump [message #528332 is a reply to message #528327] Mon, 24 October 2011 05:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"immediate trace" events are not recorded as they are a ONE TIME immediate trace.

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528334 is a reply to message #528332] Mon, 24 October 2011 05:49 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
But when I am trying to use event 10046, the result is similar with former events.

SYS@myrac2>oradebug setmypid
Statement processed.
SYS@myrac2>
SYS@myrac2>oradebug dump events 4
Statement processed.
SYS@myrac2>alter session set events '10046 trace name context forever, level 4'
  2  ;

Session altered.

SYS@myrac2>oradebug setmypid
Statement processed.
SYS@myrac2>
SYS@myrac2>
SYS@myrac2>oradebug dump events 4
Statement processed.



The trace file:
*** 2011-10-24 18:43:28.275
Dump event group for level SYSTEM
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life




*** 2011-10-24 18:43:44.179
KGX cleanup...
KGX Atomic Operation Log 0x2a0523e0
 Mutex 0x2a11e9e0(134, 0) idn 0 oper EXAM
 Cursor Parent uid 134 efd 5 whr 26 slp 0
 oper=DEFAULT pt1=0x2a840dec pt2=0x2a83ce20 pt3=0x2a840dbc
 pt4=(nil) u41=1 stt=0
*** 2011-10-24 18:44:15.946
Dump event group for level SYSTEM
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life

Report message to a moderator

Re: Large trace files generated in udump [message #528335 is a reply to message #528334] Mon, 24 October 2011 06:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You set a SESSION event, you dump SYSTEM event.

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528357 is a reply to message #528335] Mon, 24 October 2011 07:58 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
Thanks for giving me a cool method. Smile

*** 2011-10-26 06:17:01.698
Dump event group for level SYSTEM
TC Addr  Evt#(b10)   Action   TR Addr    Arm    Life
36042A04 10046       1       36042a70 0 0
        TR Name             TR level   TR address       TR arm     TR life    TR type
        CONTEXT                       4 0         -1          2  952320028


I will check it.

Report message to a moderator

Re: Large trace files generated in udump [message #528695 is a reply to message #528357] Wed, 26 October 2011 08:06 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, Michel
I have already check system events status. No any system events has been turn on.
So I raise a SR.
Thanks again.

Report message to a moderator

Re: Large trace files generated in udump [message #528698 is a reply to message #528695] Wed, 26 October 2011 08:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This was the best decision. Wink
Tell us the result.

Regards
Michel

Report message to a moderator

Re: Large trace files generated in udump [message #528714 is a reply to message #528698] Wed, 26 October 2011 08:53 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
No problem. Surprised

Report message to a moderator

Re: Large trace files generated in udump [message #530367 is a reply to message #528714] Mon, 07 November 2011 23:07 Go to previous messageGo to next message
snowball
Messages: 229
Registered: April 2006
Location: China
Senior Member
Hi, all
After asked the support engineer, they said this may cause by a bug. They're not 100% sure about this. Because some similar issues have fixed in 10.2.0.4.
A patch will need to apply and if this patch can't solve the problem, then database should upgrade to the latest version.
If this issue still exists in the latest version, then it should be report as a new bug, otherwise this can't be raise a bug as 10.2.0.4 has higher release.
Hope someone who met similar issue can get some info from this.

Thanks very much.
Milo

Report message to a moderator

Re: Large trace files generated in udump [message #530401 is a reply to message #530367] Tue, 08 November 2011 01:09 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel

Report message to a moderator

Previous Topic: montoring autoallocate tablespaces
Next Topic: Elapsed time in AWR report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 29 04:42:01 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.