Re: Serious Issue in oracle

From: Jeremiah Wilton <jwilton_at_bluegecko.net>
Date: Mon, 25 Jan 2010 09:43:29 -0800
Message-Id: <B71C73B0-3863-41A8-9987-3F9CCA949F2B_at_bluegecko.net>

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:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm#PFGRF02410

Regards,

Jeremiah Wilton
Blue Gecko, Inc.
http://www.bluegecko.net

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.

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

Received on Mon Jan 25 2010 - 11:43:29 CST