Home » RDBMS Server » Performance Tuning » Resource busy during stats gather (Oracle 10g)
Resource busy during stats gather [message #446278] Sun, 07 March 2010 08:11 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Hi,
My stats job failed yesterday with below error on few tables.

ORA-00054: resource busy and acquire with NOWAIT specified

Can someone help me how do i find out what was locking those object during that time? where should i look for details.

Thanks
Re: Resource busy during stats gather [message #446282 is a reply to message #446278] Sun, 07 March 2010 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't think dbms_stats can return this.
I'm sure ANALYZE can.

So do not use ANALYZE, use dbms_stats.

Regards
Michel
Re: Resource busy during stats gather [message #446283 is a reply to message #446278] Sun, 07 March 2010 08:48 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks Mike,That was a very good point. i willdo more R&D.Thank you.
Previous Topic: Autotrace (merged by CM)
Next Topic: Tune "where col in (val1,val2,val3)
Goto Forum:
  


Current Time: Fri Dec 09 08:10:41 CST 2016

Total time taken to generate the page: 0.20016 seconds