its 8.1.7.3, doubt its in archivelog mode. you know how to check from the data dictionary? tried v$parameter, but cant figure out which param=archivelog mode?

our data is read only. no transactions which is why I doubt redo logs. Our inserts are part of the data load.


>
> From: "Govindan K" <[Email Address Removed] Date: 2003/04/30 Wed PM 02:13:56 EDT
> To: "LazyDBA.com Discussion" <[Email Address Removed] [Email Address Removed] Subject: Re: Why is my insert blocked?
>
> 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] >To subscribe: send a blank email to oracledba-[Email Address Removed] >Visit 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