RE: Oracle 10g hangs ...earlier running smoothly

I suspect the archiver is hung, or the recovery file is full. 
 


From: ganstadba@xxxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle 10g hangs ...earlier running smoothly
Date: Tue, 19 May 2009 12:41:47 -0400





 
Don’t rule out a bug, I forget the bug number but it’s in 9i where a select on 
a table while it’s truncating causes the whole system to hang. I ran into this 
bug and it showed the same symptoms you describe though it’s on hp-ux. It did 
show up as a ora- in the alert log and did dump a trace file which you don’t 
seem to have.
_________________________________________________________________
Insert movie times and more without leaving Hotmail®.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd1_052009

Other related posts: