| last analyzed [message #58046] |
Mon, 28 July 2003 11:19  |
Surya
Messages: 34
Registered: December 2001
|
Member |
|
|
Hi,
How do you check when statistics were last generated for a particular object.
I'm using dbms_stats.gather_schema_stats but this does seem to be updating the last_analyzed column in dba_tables.
Can this information be available from any other source
Please let me know
TIA
Surya
|
|
|
|
| Re: last analyzed [message #58111 is a reply to message #58046] |
Thu, 31 July 2003 15:28  |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
You can use this statement:
select last_analyzed
from dba_tab_columns
where table_name = 'EMP'
and owner = 'SCOTT';
I developed set of GUI tools to manage, monitor and tune the Oracle database. One of the many functions is to display database, tables and other objects information. The link is http://www.barsoft.net
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
