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

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 19 May 2009 12:41:47 -0400
Message-ID: <BAY115-DAV73F3C3A2E2E81D7B001F6A65B0_at_phx.gbl>
Message-ID: <8A62C2B82E474D2BB230AEA37E1AE3DB_at_vpmcm01>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 19 2009 - 11:41:47 CDT

This message: [ Message body ]
Next message: Prem: "Re: RAC dataguard - what happens when recovering instance goes down ?"
Previous message: Barbara Baker: "Help with to_timestamp"
In reply to: Saad Khan: "Oracle 10g hangs ...earlier running smoothly"
Next in thread: Pradeep Chetal: "How can you know if your Oracle 10gr 2 (RAC-10.2.0.4) has a particular bug fixed in there - [[ Bug# 4519477 - AQ dequeue by correlation id is extremely expensive ]]"
Reply: Pradeep Chetal: "How can you know if your Oracle 10gr 2 (RAC-10.2.0.4) has a particular bug fixed in there - [[ Bug# 4519477 - AQ dequeue by correlation id is extremely expensive ]]"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message