good evening, i want to know what is problem in server oracle: THANK :)
Fri Aug 28 09:22:39 2009
GES: Potential blocker (pid=20853) on resource TX-0x19002f-0x1aee2;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:23:49 2009
GES: Potential blocker (pid=18635) on resource TX-0x1e0021-0x182b0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_20853.trc and DIAG trace file
Fri Aug 28 09:25:12 2009
GES: Potential blocker (pid=20853) on resource TX-0x19002f-0x1aee2;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_24674.trc and DIAG trace file
Fri Aug 28 09:25:28 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:25:56 2009
GES: Potential blocker (pid=18635) on resource TX-0x1e0021-0x182b0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_23612.trc and DIAG trace file
Fri Aug 28 09:28:04 2009
GES: Potential blocker (pid=18635) on resource TX-0x1e0021-0x182b0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=20853) on resource TX-0x19002f-0x1aee2;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:30:09 2009
GES: Potential blocker (pid=18635) on resource TX-0x1e0021-0x182b0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:30:57 2009
GES: Potential blocker (pid=20970) on resource TX-0x1b0018-0xc40f;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_30232.trc and DIAG trace file
Fri Aug 28 09:32:57 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:33:22 2009
GES: Potential blocker (pid=24006) on resource TX-0x380028-0x9313;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:34:17 2009
GES: Potential blocker (pid=14437) on resource TX-0x2e002c-0x6635;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:35:04 2009
GES: Potential blocker (pid=24090) on resource TX-0x300024-0x6537;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_28386.trc and DIAG trace file
Fri Aug 28 09:35:13 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_5617.trc and DIAG trace file
Fri Aug 28 09:35:17 2009
GES: Potential blocker (pid=8578) on resource TX-0x5a002b-0x2c88;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:35:57 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_6839.trc and DIAG trace file
Fri Aug 28 09:40:22 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:40:34 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_15502.trc and DIAG trace file
Fri Aug 28 09:40:44 2009
GES: Potential blocker (pid=8578) on resource TX-0x5a002b-0x2c88;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:40:50 2009
GES: Potential blocker (pid=1376) on resource TX-0x100027-0x344dc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_15922.trc and DIAG trace file
Fri Aug 28 09:41:39 2009
GES: Potential blocker (pid=14437) on resource TX-0x2e002c-0x6635;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:42:49 2009
GES: Potential blocker (pid=24006) on resource TX-0x380028-0x9313;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_15949.trc and DIAG trace file
Fri Aug 28 09:43:28 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:45:30 2009
GES: Potential blocker (pid=18582) on resource TX-0x720020-0x11e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:45:38 2009
GES: Potential blocker (pid=14437) on resource TX-0x2e002c-0x6635;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_20919.trc and DIAG trace file
Fri Aug 28 09:45:57 2009
GES: Potential blocker (pid=10557) on resource TX-0x66000c-0x2cb3;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_22345.trc and DIAG trace file
Fri Aug 28 09:46:03 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:46:25 2009
GES: Potential blocker (pid=2246) on resource TX-0x36001c-0x9de1;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:46:30 2009
GES: Potential blocker (pid=12421) on resource TX-0x1e000c-0x182d9;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_4256.trc and DIAG trace file
Fri Aug 28 09:46:31 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:47:36 2009
GES: Potential blocker (pid=13501) on resource TX-0x68000b-0x30fc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:48:25 2009
GES: Potential blocker (pid=15643) on resource TX-0x710004-0x1761;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=29803) on resource TX-0x540002-0x2c21;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:49:11 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_3513.trc and DIAG trace file
Fri Aug 28 09:49:14 2009
GES: Potential blocker (pid=3922) on resource TX-0x560022-0x21bb;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_21003.trc and DIAG trace file
Fri Aug 28 09:49:31 2009
GES: Potential blocker (pid=25710) on resource TX-0x18001d-0x18860;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_11672.trc and DIAG trace file
Fri Aug 28 09:50:04 2009
GES: Potential blocker (pid=2192) on resource TX-0x2c0023-0x7754;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_23612.trc and DIAG trace file
Fri Aug 28 09:50:52 2009
GES: Potential blocker (pid=1376) on resource TX-0x100027-0x344dc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_30628.trc and DIAG trace file
Fri Aug 28 09:51:38 2009
GES: Potential blocker (pid=24153) on resource TX-0x240015-0x80d8;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:51:48 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_22780.trc and DIAG trace file
Fri Aug 28 09:52:44 2009
GES: Potential blocker (pid=12450) on resource TX-0x6c000a-0x1e2b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:52:58 2009
GES: Potential blocker (pid=20985) on resource TX-0x7d0013-0x1ee6;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_848.trc and DIAG trace file
Fri Aug 28 09:53:57 2009
GES: Potential blocker (pid=24006) on resource TX-0x380028-0x9313;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:54:37 2009
GES: Potential blocker (pid=1376) on resource TX-0x100027-0x344dc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_31925.trc and DIAG trace file
Fri Aug 28 09:55:20 2009
GES: Potential blocker (pid=1431) on resource TX-0x340007-0x8b24;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:55:27 2009
GES: Potential blocker (pid=26709) on resource TX-0xb002e-0x2cff9;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_4579.trc and DIAG trace file
Fri Aug 28 09:58:02 2009
GES: Potential blocker (pid=30200) on resource TX-0x810027-0x16c0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=15643) on resource TX-0x710004-0x1761;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=22987) on resource TX-0x1c0012-0x1b177;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:58:09 2009
GES: Potential blocker (pid=13501) on resource TX-0x68000b-0x30fc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_30229.trc and DIAG trace file
Fri Aug 28 09:58:11 2009
GES: Potential blocker (pid=3924) on resource TX-0x600026-0x1ead;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:58:30 2009
GES: Potential blocker (pid=1431) on resource TX-0x340007-0x8b24;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:58:56 2009
GES: Potential blocker (pid=3922) on resource TX-0x560022-0x21bb;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_8534.trc and DIAG trace file
Fri Aug 28 09:59:01 2009
GES: Potential blocker (pid=20920) on resource TX-0x84000f-0xab0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_4441.trc and DIAG trace file
Fri Aug 28 09:59:26 2009
GES: Potential blocker (pid=30200) on resource TX-0x810027-0x16c0;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 09:59:27 2009
GES: Potential blocker (pid=15643) on resource TX-0x710004-0x1761;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_8561.trc and DIAG trace file
Fri Aug 28 10:00:39 2009
GES: Potential blocker (pid=32622) on resource TX-0x13001f-0x47d46;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:00:51 2009
GES: Potential blocker (pid=13505) on resource TX-0x6f000a-0x2883;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_11763.trc and DIAG trace file
Fri Aug 28 10:01:20 2009
GES: Potential blocker (pid=1376) on resource TX-0x100027-0x344dc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_11582.trc and DIAG trace file
Fri Aug 28 10:01:54 2009
GES: Potential blocker (pid=8825) on resource TX-0x690005-0x193c;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_11580.trc and DIAG trace file
Fri Aug 28 10:02:04 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:02:37 2009
GES: Potential blocker (pid=26709) on resource TX-0xb002e-0x2cff9;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:04:05 2009
GES: Potential blocker (pid=19393) on resource TX-0x77000e-0x12af;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:04:23 2009
GES: Potential blocker (pid=1431) on resource TX-0x340007-0x8b24;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:04:36 2009
GES: Potential blocker (pid=15643) on resource TX-0x710004-0x1761;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=14437) on resource TX-0x2e002c-0x6635;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:05:08 2009
GES: Potential blocker (pid=12509) on resource TX-0x94000e-0xae1;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_18443.trc and DIAG trace file
Fri Aug 28 10:05:13 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_18973.trc and DIAG trace file
Fri Aug 28 10:05:41 2009
GES: Potential blocker (pid=3924) on resource TX-0x600026-0x1ead;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_18389.trc and DIAG trace file
Fri Aug 28 10:05:43 2009
GES: Potential blocker (pid=24006) on resource TX-0x380028-0x9313;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_18591.trc and DIAG trace file
Fri Aug 28 10:06:07 2009
GES: Potential blocker (pid=29803) on resource TX-0x540002-0x2c21;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:06:21 2009
GES: Potential blocker (pid=21977) on resource TX-0x32000b-0x63f4;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:07:55 2009
GES: Potential blocker (pid=22838) on resource TX-0x87001a-0x1049;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:08:48 2009
GES: Potential blocker (pid=10584) on resource TX-0x6e000d-0x1b96;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=8578) on resource TX-0x5a002b-0x2c88;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:09:18 2009
GES: Potential blocker (pid=17329) on resource TX-0x9f0010-0x63f;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:09:24 2009
GES: Potential blocker (pid=13916) on resource TX-0x2a0013-0x818e;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_21941.trc and DIAG trace file
Fri Aug 28 10:09:28 2009
GES: Potential blocker (pid=8691) on resource TX-0x8f0027-0x810;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:10:06 2009
GES: Potential blocker (pid=1431) on resource TX-0x340007-0x8b24;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:11:41 2009
GES: Potential blocker (pid=28771) on resource TX-0x530012-0x33e3;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_27677.trc and DIAG trace file
Fri Aug 28 10:16:11 2009
GES: Potential blocker (pid=13319) on resource TX-0x22001c-0x84e5;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_27648.trc and DIAG trace file
Fri Aug 28 10:17:32 2009
GES: Potential blocker (pid=13501) on resource TX-0x68000b-0x30fc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29755.trc and DIAG trace file
Fri Aug 28 10:19:51 2009
GES: Potential blocker (pid=1376) on resource TX-0x100027-0x344dc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29747.trc and DIAG trace file
Fri Aug 28 10:19:51 2009
GES: Potential blocker (pid=1149) on resource TX-0xf000a-0x2df5b;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
GES: Potential blocker (pid=27808) on resource TX-0xa70029-0x7e8;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:20:01 2009
GES: Potential blocker (pid=15169) on resource TX-0x70001a-0x2109;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29475.trc and DIAG trace file
Fri Aug 28 10:20:20 2009
GES: Potential blocker (pid=15643) on resource TX-0x710004-0x1761;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_27158.trc and DIAG trace file
Fri Aug 28 10:20:25 2009
GES: Potential blocker (pid=32622) on resource TX-0x13001f-0x47d46;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29170.trc and DIAG trace file
Fri Aug 28 10:20:44 2009
GES: Potential blocker (pid=12019) on resource TX-0x8c0008-0xa91;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29197.trc and DIAG trace file
Fri Aug 28 10:21:58 2009
GES: Potential blocker (pid=23872) on resource TX-0xc0023-0x32efc;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_15599.trc and DIAG trace file
Fri Aug 28 10:23:28 2009
GES: Potential blocker (pid=14155) on resource TX-0xa1000e-0x763;
enqueue info in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc and DIAG trace file
Fri Aug 28 10:23:29 2009
GES: Potential blocker (pid=28771) on resource TX-0x530012-0x33e3;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29562.trc and DIAG trace file
Fri Aug 28 10:23:30 2009
GES: Potential blocker (pid=846) on resource TX-0x820020-0x134d;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29558.trc and DIAG trace file
Fri Aug 28 10:23:33 2009
GES: Potential blocker (pid=22985) on resource TX-0x7e0001-0x1044;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29595.trc and DIAG trace file
Fri Aug 28 10:24:15 2009
GES: Potential blocker (pid=29248) on resource TX-0xc10005-0x352;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_29209.trc and DIAG trace file
Fri Aug 28 10:28:12 2009
Error: unexpected error (6) from the Cluster Service (LCK0)
Fri Aug 28 10:28:21 2009
GES: Potential blocker (pid=3995) on resource TX-0x8b0015-0xd0e;
enqueue info in file /u01/app/oracle/admin/wfmuprod/udump/wfmuprod2_ora_12501.trc and DIAG trace file
Fri Aug 28 10:28:22 2009
Errors in file /u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lck0_24410.trc:
ORA-29702: error occurred in Cluster Group Service operation
Fri Aug 28 10:28:22 2009
LCK0: terminating instance due to error 29702
Fri Aug 28 10:35:45 2009
/u01/app/oracle/admin/wfmuprod/bdump/wfmuprod2_lmd0_24259.trc
Current SQL Statement:
DELETE PRESENZE_ITEM WHERE ID_PRESENZA IN ( SELECT ID_PRESENZA FROM PRESENZE WHERE MATRICOLA=:B3 AND DATA>=TRUNC(:B2 ) AND DATA<=N
VL(TRUNC(:B1 ),DATA) )
Global blockers dump start
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
UPDATE PRESENZE SET STRINGA=:B2 WHERE ID_PRESENZA=:B1
user session for deadlock lock 0x15f51f1b0
pid=77 serial=12147 audsid=3506952 user: 44/WFMUPROD
O/S info: user: jboss, term: unknown, ospid: 1234, machine: WFMU-FE1
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
DELETE PRESENZE_ITEM WHERE ID_PRESENZA IN ( SELECT ID_PRESENZA FROM PRESENZE WHERE MATRICOLA=:B3 AND DATA>=TRUNC(:B2 ) AND DATA<=N
VL(TRUNC(:B1 ),DATA) )
Global blockers dump start:---------------------------------
DUMP LOCAL BLOCKER/HOLDER: block level 5 res [0x8f0025][0x7e4],[TX]
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
UPDATE PRESENZE SET FLAG_VALIDA=:B4 WHERE MATRICOLA=:B3 AND DATA>=TRUNC(:B2 ) AND DATA<=NVL(TRUNC(:B1 ),DATA)
user session for deadlock lock 0x15f4cf0b0
pid=59 serial=18445 audsid=3513296 user: 44/WFMUPROD
O/S info: user: jboss, term: unknown, ospid: 1234, machine: WFMU-FE1
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
UPDATE PRESENZE SET FLAG_VALIDA=:B4 WHERE MATRICOLA=:B3 AND DATA>=TRUNC(:B2 ) AND DATA<=NVL(TRUNC(:B1 ),DATA)
Global blockers dump start:---------------------------------
DUMP LOCAL BLOCKER/HOLDER: block level 3 res [0x190013][0x1a566],[TX]
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
UPDATE PRESENZE SET STRINGA=:B2 WHERE ID_PRESENZA=:B1
user session for deadlock lock 0x15d5e06a8
pid=86 serial=18444 audsid=3514022 user: 44/WFMUPROD
O/S info: user: jboss, term: unknown, ospid: 1234, machine: WFMU-FE1
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=0
Current SQL Statement:
DELETE PRESENZE_ITEM WHERE ID_PRESENZA IN ( SELECT ID_PRESENZA FROM PRESENZE WHERE MATRICOLA=:B3 AND DATA>=TRUNC(:B2 ) AND DATA<=N
VL(TRUNC(:B1 ),DATA) )
Global blockers dump start:---------------------------------
DUMP LOCAL BLOCKER/HOLDER: block level 3 res [0x340002][0x8565],[TX]
Edited by: gsflash80 on Sep 2, 2009 5:28 PM