Re: dabase hang on update statement

2002-09-30 Thread Joan Hsieh
on't tell you > why it's waiting, but you'll know which area to look at. > > Jared > > Joan Hsieh <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 09/30/2002 08:08 AM > Please respond to ORACLE-L > > > To: Multiple recipients of l

Re: dabase hang on update statement

2002-09-30 Thread Jared . Still
n Hsieh <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/30/2002 08:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: dabase hang on update statement Hi list, oracle 8.1.7.2 os AIX 4.3.

dabase hang on update statement

2002-09-30 Thread Joan Hsieh
Hi list, oracle 8.1.7.2 os AIX 4.3.3 Occasionally we had hang situation on our Financial production database. The batch job supposed to finish within 2 hours at 3:30 am. But sometimes it just hang there and never finished the process. We have to kill the job in oracle session and os level. Since