you can lock statistics. I'm guessing this means that the stats for this table will never change (until at least you lock them).
to lock statistics try:
dbms_stats.lock_table_stats(owner, tablename);
there should be additional parameters to lock column and index statistics as well.
Use the dba_tab_statistics view to verify what tables have been locked.
Everything Changes
1 week ago