Re: Re: Why is my insert blocked?

Re: Re: Why is my insert blocked?

 

  

Ill check the alert log tomorrow morning.

sorry about read only... was busy today and wasnt clear. We use this
instance for data loads. Users dont do transactions. So its essentially
'read only' from the users perspective. Sorry internal terminology. So I
didnt think we were in archive log mode, since it would be wasteful. Cold
backup is plenty for this.



----- Original Message -----
From: "Govindan K" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, April 30, 2003 4:59 PM
Subject: Re: Re: Why is my insert blocked?


> /home/govindank yamuna:MEFNG>sqlplus /nolog
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 30 13:53:34 2003
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> connect sys as sysdba
> Enter password:
> Connected.
> SQL> archive log list
> Database log mode No Archive Mode
> Automatic archival Disabled
> Archive destination /u005/oracle/product/9.2.0/dbs/arch
> Oldest online log sequence 263044
> Current log sequence 263046
> SQL>
>
> What do you mean by saying read-only. Is the tablespace mounted as online
and read-only. Is the insert taking place thru pl/sql and any exception when
other being ignored/set to null?. Also what is the alert log file is
saying?. How is the insert taking place (sqlldr/plsql/sql/pro*c)?
>
> ---
> HTH
>
> GovindanK
>
>
> On Wed, 30 Apr 2003 15:37:35
> rgaffuri 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.
> >
> >
> >>
> >> 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 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 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
>

Oracle LazyDBA home page