SQL Performance (MOSC)

MOSC Banner

Export of fixed object statistics return empty table

edited Oct 6, 2017 5:00AM in SQL Performance (MOSC) 2 commentsAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center