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.
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: 25848
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.
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.
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.
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: 25848
Registered: January 2009
Location: SoCal
Senior Member
STOP SPAMMING THIS FORUM!
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.

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.

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: 25848
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.
Previous Topic: advice to rewrite a query with a bad desing
Next Topic: Updating compressed rows
Goto Forum:
  


Current Time: Sat Feb 17 17:29:46 CST 2018

Total time taken to generate the page: 0.04055 seconds