Re: Serious Issue in oracle
Date: Mon, 25 Jan 2010 09:43:29 -0800
Based on what evidence does this sound like a deadlock? Nobody has mentioned ORA-60. If what you mean instead is 'blocking lock' then there is also no evidence to support this assertion.
Oracle has detailed instrumentation. When something hangs, we look at the wait event for that session in v$session (v$session_wait in 9i and earlier). There is no reason for conjecture in a product that simply tells you what it is hanging on in plain english.
Amit, you will benefit from familiarizing yourself with wait events for diagnosing both performance and hanging issues. There are many articles you can read to get started, but the documentation is also a great place to start:
Blue Gecko, Inc.
On Jan 25, 2010, at 6:39 AM, lyallbarbour_at_sanfranmail.com wrote:
> Sounds like a deadlock situation. No errors in the alert
> log? ...Before you bounced the DB? Can you recreate the problem
> now that it's gone? Maybe Gremlins.... they like to cause
> havoc... :)
> -----Original Message-----
> From: AMIT VERMA <verma.labs_at_gmail.com>
> Sent: Sun, Jan 24, 2010 2:21 pm
> ...The table was become non - responsive or hung, we had run the
> select statement only. There is no error in the alert log ... Thus
> we have restarted the db ... the table become responsive.