sqlt 9i is reporting SYSTEM STATS-CPUSPEED-WORKLOAD SYSTEM STATISTICS are missing.
The sqlt9i report for a query using reported SYSTEM STATS-CPUSPEED-WORKLOAD SYSTEM STATISTICS are missing..
When I tried to run the Workload statistics again this error appeared:
SQL> conn /as sysdba
Connected.
SQL> alter session set nls_date_format='DD-MM-YY hh24:mi:ss';
Session altered.
SQL> set serveroutput on ;
SQL> exec DBMS_STATS.CREATE_STAT_TABLE ('SYS','sys_stats');
BEGIN DBMS_STATS.CREATE_STAT_TABLE ('SYS','sys_stats'); END;
*
ERROR at line 1:
ORA-20002: Unable to create table SYS_STATS: already exists
ORA-06512: at "SYS.DBMS_STATS", line 5339
ORA-06512: at line 1
SQL>
SQL> conn /as sysdba
Connected.
SQL> alter session set nls_date_format='DD-MM-YY hh24:mi:ss';
Session altered.
SQL> set serveroutput on ;
SQL> exec DBMS_STATS.CREATE_STAT_TABLE ('SYS','sys_stats');
BEGIN DBMS_STATS.CREATE_STAT_TABLE ('SYS','sys_stats'); END;
*
ERROR at line 1:
ORA-20002: Unable to create table SYS_STATS: already exists
ORA-06512: at "SYS.DBMS_STATS", line 5339
ORA-06512: at line 1
SQL>
0