Home » RDBMS Server » Performance Tuning » Table Stats running
Table Stats running [message #210345] Wed, 20 December 2006 07:58 Go to next message
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??

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)

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
Messages: 611
Registered: July 2006
Senior Member
Look at DBA_TABLES and DBA_INDEXES for LAST_ANALYZED column value.

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

Current Time: Sat Oct 22 02:30:35 CDT 2016

Total time taken to generate the page: 0.06684 seconds