Is your database in Archivelog mode? If so may be it is waiting for log switch to happen? Did you check the alert log?.
Is your database on 9i? If so , is any suspend related feature turned on?

---
HTH

GovindanK

On Wed, 30 Apr 2003 13:48:50
rgaffuri wrote:
>Im trying to do an insert and its hanging, which means there is a lock. So we are killing all the sessions. Now noone has issued an explicit lock table when when you do an 'insert' you are adding a row so how could the table be locked?
>
>Is there a way to time out an insert statement that is blocked due to a lock? I know with Select you have to explicitly issue a 'NOWAIT' in order to have your query wait without timing out. Or am I wrong on that one?
>
>
>--------
>Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>


____________________________________________________________
Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail!
http://login.mail.lycos.com/r/referral?aid=27005
Oracle LazyDBA home page