Home » SQL & PL/SQL » SQL & PL/SQL » Statistics locked (Oracle 10g)
Statistics locked [message #330796] Tue, 01 July 2008 05:19 Go to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Dear All,
Am trying to gather stats but am getting an error message as
" object statistics are locked (stattype = ALL) ".So am not bale to gather stats.What needs to be done?Kindly suggests...
Re: Statistics locked [message #330797 is a reply to message #330796] Tue, 01 July 2008 05:23 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Was it an ORA-38029?

ORA-38029:	object statistics are locked
Cause:	An attept was made to modify optimizer statistics 
        of the object.
Action:	Unlock statistics with the DBMS_STATS.UNLOCK_TABLE_STATS 
        procedure on base table(s). Retry the operation if it is
        okay to update statistics.
Re: Statistics locked [message #330800 is a reply to message #330797] Tue, 01 July 2008 05:55 Go to previous messageGo to next message
subbu_tce
Messages: 98
Registered: July 2007
Location: pune
Member
Thanks.But why it has been locked ?
Re: Statistics locked [message #330804 is a reply to message #330800] Tue, 01 July 2008 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
By the same package.

Regards
Michel
Re: Statistics locked [message #330806 is a reply to message #330796] Tue, 01 July 2008 06:06 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
> But why it has been locked ?
Good question, but wrong interviewee, as nobody in this forum knows more about your DB than you posted here.
Definitely you shall ask the database administrator (DBA) or people working on the schema you accessed.
Previous Topic: Query Slow
Next Topic: derive sub-total of one column and divide by another column's distinct value?
Goto Forum:
  


Current Time: Sat Dec 03 04:11:38 CST 2016

Total time taken to generate the page: 0.21963 seconds