Re: Re: Why is my insert blocked?

Re: Re: Why is my insert blocked?

 

  

select log_mode from v$database;

--- [Email Address Removed] wrote:
> 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.


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
Oracle LazyDBA home page