OraFAQ Forum: Performance Tuning » Table Stats running

Home » RDBMS Server » Performance Tuning » Table Stats running

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

Table Stats running [message #210345]

Wed, 20 December 2006 07:58

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

Report message to a moderator

Re: Table Stats running [message #210564 is a reply to message #210345]

Thu, 21 December 2006 05:55

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Re: Table Stats running [message #210851 is a reply to message #210345]

Fri, 22 December 2006 11:47

michael_bialik
Messages: 621
Registered: July 2006

Senior Member

Look at DBA_TABLES and DBA_INDEXES for LAST_ANALYZED column value.

HTH.

Report message to a moderator

Previous Topic:	Oracle Database Slow
Next Topic:	about sql tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 10:41:35 CST 2024