Hi,
There is a request from app team to gather stats for table.
My findings
SQL> select owner,table_name,LAST_ANALYZED from dba_tables where table_name='/BIC/FZFIAR_C03';
OWNER TABLE_NAME LAST_ANALYZED
------------------------------ ------------------------------ ---------------
SAPSR3 /BIC/FZFIAR_C03 15-OCT-16
These many users available in the database.
SQL> select count(*) from v$session where status='ACTIVE';
COUNT(*)
----------
74
SQL> select count(*) from v$session where status='INACTIVE';
COUNT(*)
----------
274
When I try to gather stats for table, I am getting below errors in the DB. Could you please help me on this to gather stats for table.
SQL> exec dbms_stats.gather_table_stats('SAPSR3','/BIC/FZFIAR_C03');
BEGIN dbms_stats.gather_table_stats('SAPSR3','/BIC/FZFIAR_C03'); END;
*
ERROR at line 1:
ORA-20001: /BIC/FZFIAR_C03 is an invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 24676
ORA-06512: at "SYS.DBMS_STATS", line 24734
ORA-06512: at line 1
Exadata -- 11.2.0.4.0
OS -- Linux
This is 2 node RAC
Regards,
Bala