script by last analyzed database

[heyeveto]

Hi;

Give me a script that can tell me when was the last time you ran statistics level scheme

[amitpatel66]

Hi;

Give me a script that can tell me when was the last time you ran statistics level scheme

Could you please be more specific to what you are looking at?

[subashsavji]

Hi;

Give me a script that can tell me when was the last time you ran statistics level scheme

MAY THIS WILL HELP YOU

exec dbms_stats.export_column_stats(USER, 'servers', 'srvr_id', NULL, 'STAT_TAB');
//

exec dbms_stats.export_database_prefs('STAT_TAB', statown=> USER);
//

exec dbms_stats.export_database_stats;
//

exec dbms_stats.flush_database_monitoring_info;
//
BEGIN
 DBMS_DDL.ANALYZE_OBJECT('TABLE','SYS','X','COMPUTE');
 END;
 /

SELECT * FROM USER_TABLES WHERE TABLE_NAME='X';
//