| GATHER_SCHEMA_STATS - monitoring progress? [message #204642] |
Tue, 21 November 2006 08:32  |
gwicke
Messages: 2
Registered: November 2006
Location: Indianapolis, IN USA
|
Junior Member |
|
|
Greetings
When running DBMS_STATS.GATHER_SCHEMA_STATS and having all tables in MONITORIING mode, is there a way to monitor the progress of the statistic gathering process?
I realize the process will take various times based on the number of objects it believes it needs to analyze, however, my process takes consistently about 90 minutes give or take 10%. Every now and then the process runs over 3 hours.
My gut tells me it's NOT due to an large increase in new data so I'm looking for a way to monitor the progress of the gathering process so I can check it manually or even write progress steps out to a log file.
Many thanks for the help.
-gary
|
|
|
|
| Re: GATHER_SCHEMA_STATS - monitoring progress? [message #204648 is a reply to message #204642] |
Tue, 21 November 2006 09:00  |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
You can query DBA_TABLES, DBA_TAB_COLUMNS, DBA_INDEXES andDBA_TAB_COL_STATISTICS and look at the LAST_ANALYZED.
If you check how many of these are after the date/time that you started Dbms_stats going, you should be able to get an idea of the progress.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
