object statistics are locked
650105Feb 10 2010 — edited Feb 10 2010hello
when i ran the following query i got the list of all those object whose statistic are locked. i have unlocked statistic all schema object successfully but some of SYS objects still shows lock. plz clarify the concept plz
select owner, table_name, stattype_locked from dba_tab_statistics where stattype_locked is not null
exec dbms_stats.unlock_schema_stats('SYS');
after running i get 19 SYS table still statistic are locked what would be the reason of it.