How to check Lock SQL

From: Sanjay Mishra <smishra_97_at_yahoo.com>
Date: Tue, 22 Feb 2005 09:33:58 -0800 (PST)
Message-ID: <20050222173358.32075.qmail@web51302.mail.yahoo.com>

I think that mine previous question is not suitably explained by me and so I didn't get any response and so I though that I will give some more facts

I check the program running at the back end and found that it is only doing insert by tracing the program.

So if I am getting Resource Busy error, can I get the sql from dictionary view which can tell as what particular SQL is making the lock as then I can pass it to Development group with more suggestion

THanks to all
Sanjay

Sanjay Mishra <smishra_97_at_yahoo.com> wrote:

> Dear friend
>
> We have deployed a production change today. Change
> incloves a Pro*C program running at backed from
> Application server and doing some insert into the
> table 1,2,3 based on certain condition. This is now
> taking an exclusive index on the Table1 Primary Key
> Partitioned index. Table1 is partition Locally and
> new
> partition are created daily. Due to lock, I am not
> able to add partition. Can somebody point as what
> need
> to be checked.
>
> Table1 is having One primary Key and one Foreign
> Key.
> Table1 is partitioned Locally. It has exclusive lock
> on table1 Primary Key index partiton and Row
> exclusinve for table partition.
>
> Any comment
> TIA
> sanjay
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> --
> http://www.freelists.org/webpage/oracle-l
>

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 22 2005 - 12:36:58 CST

How to check Lock SQL - Please help