Re: silly dbms_stats question
- From: GBA-DBA <gba.oraclel@xxxxxxxxx>
- To: Jon.Crisler@xxxxxxx
- Date: Fri, 24 Apr 2009 11:00:16 -0500
user_ind_statistics for indexes
user_tab_statistics for tables
On Fri, Apr 24, 2009 at 10:49 AM, Crisler, Jon <Jon.Crisler@xxxxxxx> wrote:
> I have never been able to figure out what view shows when a table was
> last analyzed with DBMS_STATS in Oracle 10g.
>
> I know that dba_tables column “last_analyzed” does not reflect
> dbms_stats. DBA_TAB_MODIFICATIONS tracks monitoring for dbms_stats, but it
> does not track when dbms_stats was run.
>
>
>
> I am trying to write some queries to determine which tables need to have
> dbms_stats run more frequently, and I want to join dba_tab_modifications to
> the view that tracks the last dbms_stats run.
>
>
>
> Any ideas what view tracks last dbms_stats run on a table ?
> -- //www.freelists.org/webpage/oracle-l
--
Regards
GBA
Other related posts:
