Re: Re: Why is my insert blocked?

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] 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