OraFAQ Forum: Performance Tuning » Resource busy during stats gather

Home » RDBMS Server » Performance Tuning » Resource busy during stats gather (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Resource busy during stats gather [message #446278]

Sun, 07 March 2010 08:11

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

Report message to a moderator

Re: Resource busy during stats gather [message #446282 is a reply to message #446278]

Sun, 07 March 2010 08:39

Michel Cadot
Messages: 68650
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

Report message to a moderator

Re: Resource busy during stats gather [message #446283 is a reply to message #446278]

Sun, 07 March 2010 08:48

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.

Report message to a moderator

Previous Topic:	Autotrace (merged by CM)
Next Topic:	Tune "where col in (val1,val2,val3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 11 13:35:31 CDT 2024