OraFAQ Forum: Server Administration » Transaction of Specific date locked

Home » RDBMS Server » Server Administration » Transaction of Specific date locked (oracle 9i release 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Transaction of Specific date locked [message #438505]

Sun, 10 January 2010 00:44

abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal

Member

My transaction of 1 day Jan7,2009 cannot be manipulated by any DML..
What shud i do to unlock those records...??

Report message to a moderator

Re: Transaction of Specific date locked [message #438507 is a reply to message #438505]

Sun, 10 January 2010 01:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>My transaction of 1 day Jan7,2009 cannot be manipulated by any DML..
>What shud i do to unlock those records...??

HOW can we reproduce this issue?

Report message to a moderator

Re: Transaction of Specific date locked [message #438513 is a reply to message #438505]

Sun, 10 January 2010 01:36

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

My transaction of 1 day Jan7,2009 cannot be manipulated by any DML..

What does this mean?
A transaction is manipulated by nothing.
You can start it, you can end it, that's all.

Regards
Michel

Report message to a moderator

Re: Transaction of Specific date locked [message #438516 is a reply to message #438505]

Sun, 10 January 2010 02:10

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

You did not gave very much information. So..a wild guess:

Probably your data is locked by another session/transaction. Find out which one it is and decide whether to stop this transaction.

Report message to a moderator

Re: Transaction of Specific date locked [message #438589 is a reply to message #438516]

Mon, 11 January 2010 02:11

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Quote:

My transaction of 1 day Jan7,2009 cannot be manipulated by any DML..
What shud i do to unlock those records...??

How ? if User is updating data in A table and other user is trying select he should see Old Data unless first user commits

Does it ?

So how is Data being locked ? you should see something...

Report message to a moderator

Re: Transaction of Specific date locked [message #438591 is a reply to message #438589]

Mon, 11 January 2010 02:24

martijn
Messages: 286
Registered: December 2006
Location: Netherlands

Senior Member

rahulvb wrote on Mon, 11 January 2010 09:11

Quote:

My transaction of 1 day Jan7,2009 cannot be manipulated by any DML..
What shud i do to unlock those records...??

How ? if User is updating data in A table and other user is trying select he should see Old Data unless first user commits

Does it ?

Indeed
Quote:

So how is Data being locked ? you should see something...

That's right. So probably the second session tries to update something which the first one also tries to update and has not yet committed.

Try to find out what is causing the lock using v$lock

[Updated on: Mon, 11 January 2010 02:24]

Report message to a moderator

Re: Transaction of Specific date locked [message #438608 is a reply to message #438591]

Mon, 11 January 2010 03:20

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Quote:

That's right. So probably the second session tries to update something which the first one also tries to update and has not yet committed.

Then abhi_shakya should face Dead Lock ORA-00060 Error.

abhi_shakya are you getting such error/s ? if yes please go to following link Oracle parallel DML

-Rahul

[Updated on: Mon, 11 January 2010 03:21]

Report message to a moderator

Re: Transaction of Specific date locked [message #438614 is a reply to message #438608]

Mon, 11 January 2010 03:39

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Then abhi_shakya should face Dead Lock ORA-00060 Error.

Wrong, the second session would just be waiting for the lock to be released (unless it holds some lock the first session is waiting for).

Regards
Michel

Report message to a moderator

Re: Transaction of Specific date locked [message #439432 is a reply to message #438505]

Sat, 16 January 2010 14:54

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

lot of talk for a post that is not understood.

abhi_shakya, please provide additional information. It is not at all clear whay your problem is.

Do you have rows that you cannot update or delete? If so what is the error your getting?

If you truly have an unexplainable lock, try bouncing your database.

Kevin

Report message to a moderator