Home » RDBMS Server » Performance Tuning » table lock in past (Oracle 10.2.0.4.0, Aix 6.1)
table lock in past [message #631323] Mon, 12 January 2015 13:25 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member
Hi Guys,

is there any query which gives which table had been locked in past i mean some hours ago or 1 day ago?.if so please send me the query. thanks a lot in advance.


Best Regards.

Report message to a moderator

Re: table lock in past [message #631324 is a reply to message #631323] Mon, 12 January 2015 13:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
oradba123 wrote on Mon, 12 January 2015 11:25
Hi Guys,

is there any query which gives which table had been locked in past i mean some hours ago or 1 day ago?.if so please send me the query. thanks a lot in advance.


Best Regards.


does not exist.

Report message to a moderator

table lock in past [message #631325 is a reply to message #631323] Mon, 12 January 2015 13:26 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member
Hi Guys,

is there any query which gives which table had been locked in past i mean some hours ago or 1 day ago?.if so please send me the query. thanks a lot in advance.


Best Regards.

Report message to a moderator

table lock in past [message #631326 is a reply to message #631323] Mon, 12 January 2015 13:27 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member
Hi Guys,

is there any query which gives which table had been locked in past i mean some hours ago or 1 day ago?.if so please send me the query. thanks a lot in advance.


Best Regards.

Report message to a moderator

Re: table lock in past [message #631327 is a reply to message #631326] Mon, 12 January 2015 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
STOP SPAMMING THIS FORUM!

Report message to a moderator

Re: table lock in past [message #631328 is a reply to message #631327] Mon, 12 January 2015 13:38 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi,

mistakenly it has been gone in loop.


Regards.

Report message to a moderator

Re: table lock in past [message #631329 is a reply to message #631324] Mon, 12 January 2015 13:40 Go to previous messageGo to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member

Hi Black swan,

thanks a lot for you quick response


thanks & Regards.

Report message to a moderator

Re: table lock in past [message #631330 is a reply to message #631328] Mon, 12 January 2015 13:42 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
oradba123 wrote on Mon, 12 January 2015 11:38

Hi,

mistakenly it has been gone in loop.


Regards.



Problem Exists Between Keyboard And Chair, IMO.

A craftsman never blames his tools.

Report message to a moderator

Previous Topic: advice to rewrite a query with a bad desing
Next Topic: Updating compressed rows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 18:11:15 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.