Home » RDBMS Server » Performance Tuning » Table Stats running
Table Stats running [message #210345] Wed, 20 December 2006 07:58 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
I have executed a sys.dbms_stats.gather_schema_stats and it is stuck somewhere, is there a way to tell if this process is humg or which table/index it is stuck on??

Thanks
Toshi
Re: Table Stats running [message #210564 is a reply to message #210345] Thu, 21 December 2006 05:55 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can trace the session.
You can check v$session_longops (not very accurate, but can give some idea on whats happening)
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10755/dynviews_2077.htm

SCOTT > select opname,count(opname),sum(elapsed_seconds) from v$session_longops group by opname;

OPNAME                                                           COUNT(OPNAME) SUM(ELAPSED_SECONDS)
---------------------------------------------------------------- ------------- --------------------
Gather Table's Index Statistics                                              6                    1
Gather Schema Statistics                                                     2                    1

Re: Table Stats running [message #210851 is a reply to message #210345] Fri, 22 December 2006 11:47 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Look at DBA_TABLES and DBA_INDEXES for LAST_ANALYZED column value.

HTH.
Previous Topic: Oracle Database Slow
Next Topic: about sql tuning
Goto Forum:
  


Current Time: Fri Dec 09 19:33:18 CST 2016

Total time taken to generate the page: 0.26507 seconds