Home » SQL & PL/SQL » SQL & PL/SQL » Locked Stats (11)
Locked Stats [message #609202] Mon, 03 March 2014 22:01 Go to next message
blackpanther
Messages: 17
Registered: June 2010
Location: Bangalore
Junior Member
Hi,

I found today that a table has stats Locked when my gather stats on that table failed. Is there anyway to find out when the table stats were locked and who did this?

Thanks

Report message to a moderator

Re: Locked Stats [message #609203 is a reply to message #609202] Mon, 03 March 2014 22:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I found today that a table has stats Locked when my gather stats on that table failed. Is there anyway to find out when the table stats were locked and who did this?

DBMS_LOGMNR can provide these details; assuming that you have archived redo logfiles that go back to when it was done.
You can only know for sure by trying.
It might be a long & painful search which returns no definitive answer.

Report message to a moderator

Re: Locked Stats [message #609224 is a reply to message #609203] Tue, 04 March 2014 02:33 Go to previous message
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
Senior Member
It's a massive long shot, but you never know....some enterprising DBA might have populated the table comments to explain why.

Report message to a moderator

Previous Topic: dbms_output.put_line
Next Topic: Columns values into rows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 09:20:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.