Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to check Lock SQL - Please help
Hi
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
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
> 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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 22 2005 - 12:36:58 CST
![]() |
![]() |