Home » RDBMS Server » Performance Tuning » Analyze table hangs for hours (Oracle 10.2.0.4 ,linux)
Analyze table hangs for hours [message #426130] Wed, 14 October 2009 03:12 Go to next message
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
Re: Analyze table hangs for hours [message #426136 is a reply to message #426130] Wed, 14 October 2009 03:27 Go to previous messageGo to next message
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?
Re: Analyze table hangs for hours [message #426138 is a reply to message #426130] Wed, 14 October 2009 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also have a look at v$session_longops.

Regards
Michel
Re: Analyze table hangs for hours [message #426139 is a reply to message #426130] Wed, 14 October 2009 03:30 Go to previous message
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
Previous Topic: How to clear lock????
Next Topic: Execution plan for every SQL, executed by user
Goto Forum:
  


Current Time: Sun Dec 11 08:10:39 CST 2016

Total time taken to generate the page: 0.05174 seconds