Export of fixed object statistics return empty table
Hello,
I am facing some problem regarding execution of statements on fixed objects. For example :
SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)
this statement took about 68 sec, when on other database this statements took less then a 1 sec. I try to export current fixed object statistics before collecting new one with following command:
begin dbms_stats.export_fixed_objects_stats(stattab => 'FIXED_OBJ_STATS_26092017'); end;
The procedure executed successfully , but when I select the table it was empty. Is this mean that there is no statistics on this tables and how I can check this with othe view?