Knowing when ANALYZE was last run

From: Linda Lorentz <lal5241_at_bcsfse.ca.boeing.com>
Date: 1996/04/25
Message-ID: <DqFqEv.K5y_at_bcstec.ca.boeing.com>#1/1

Is there a function in Oracle that allows you to know when the last time ANALYZE was run? I would like to know how old the statistics are on a table (much like last time RUNSTATS was run on a DB2 table). Does anyone know if this information exists, and if so, where? If it exists at all, I would guess that it was somewhere in the DBA_% tables, but I have been unable to find it...

Thanks for your help!

Linda A. Lorentz
Boecom DBA
The Boeing Company Received on Thu Apr 25 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: mlanda_at_vnet.ibm.com: "Auditing and Use the Triggers"
Previous message: Richard Woods: "Re: Spatial or geographic queries"
Next in thread: wqbang: "Re: Knowing when ANALYZE was last run"
Reply: wqbang: "Re: Knowing when ANALYZE was last run"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message