OraFAQ Forum: Performance Tuning » Analyze table hangs for hours

Home » RDBMS Server » Performance Tuning » Analyze table hangs for hours (Oracle 10.2.0.4 ,linux)

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

Analyze table hangs for hours [message #426130]

Wed, 14 October 2009 03:12

sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai

Senior Member

Hi,

Analyze table hangs for hours (more than 6 hrs) using DBMS_STATS.GATHER_TABLE_STATS.At last we killed the session and then rerun it.it runs succesfully completed.

Why DBMS_STATS.GATHER_TABLE_STATS hangs for hours for some time?

is this issue arise due to the GATHER_STATS_JOB schedule or any other issue?

please help me.

Thanks,
Michael Holding

Report message to a moderator

Re: Analyze table hangs for hours [message #426136 is a reply to message #426130]

Wed, 14 October 2009 03:27

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Did you look at v$session_wait to see what the session was waiting on?

Did you check to see if it was being blocked by a lock?

Report message to a moderator

Re: Analyze table hangs for hours [message #426138 is a reply to message #426130]

Wed, 14 October 2009 03:29

Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Also have a look at v$session_longops.

Regards
Michel

Report message to a moderator

Re: Analyze table hangs for hours [message #426139 is a reply to message #426130]

Wed, 14 October 2009 03:30

balakrishnay
Messages: 54
Registered: September 2009
Location: Pune

Member

Hi,

select sum(bytes/1024/1024)"size" from dba_segments where segment_name='&name';

Give me the output of this ..

and more ever if the table size is too huge .. then you should use estimate_percent=>10

Regards

Bala

Report message to a moderator

Previous Topic:	How to clear lock????
Next Topic:	Execution plan for every SQL, executed by user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 18 05:13:34 CDT 2024