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: 3212
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: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
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: 1903
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: Thu Feb 06 22:18:58 CST 2025