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@xxxxxxxxxxxxxxx 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@xxxxxxxxx> 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.
-- //www.freelists.org/webpage/oracle-l
