Home » RDBMS Server » Server Administration » Transaction of Specific date locked (oracle 9i release 2)
Transaction of Specific date locked [message #438505] Sun, 10 January 2010 00:44 Go to next message
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...??
Re: Transaction of Specific date locked [message #438507 is a reply to message #438505] Sun, 10 January 2010 01:04 Go to previous messageGo to next message
BlackSwan
Messages: 25044
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?
Re: Transaction of Specific date locked [message #438513 is a reply to message #438505] Sun, 10 January 2010 01:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Transaction of Specific date locked [message #438516 is a reply to message #438505] Sun, 10 January 2010 02:10 Go to previous messageGo to next message
martijn
Messages: 283
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.
Re: Transaction of Specific date locked [message #438589 is a reply to message #438516] Mon, 11 January 2010 02:11 Go to previous messageGo to next message
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...

Re: Transaction of Specific date locked [message #438591 is a reply to message #438589] Mon, 11 January 2010 02:24 Go to previous messageGo to next message
martijn
Messages: 283
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Transaction of Specific date locked [message #439432 is a reply to message #438505] Sat, 16 January 2010 14:54 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
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
Re: Transaction of Specific date locked [message #442314 is a reply to message #439432] Sat, 06 February 2010 20:32 Go to previous messageGo to next message
entekeralam
Messages: 19
Registered: January 2010
Junior Member
Check the session that locks using this script below and commit or kill/rollback.

http://dbaregistry.blogspot.com/2010/02/useful-sql-scripts.html
Re: Transaction of Specific date locked [message #442410 is a reply to message #442314] Sun, 07 February 2010 21:48 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Better post the solution...not a link As it refers to your Blog.

sriram Smile
Previous Topic: Database version change
Next Topic: Best way to kill a oracle session
Goto Forum:
  


Current Time: Wed Dec 07 08:41:53 CST 2016

Total time taken to generate the page: 0.09592 seconds