Oracle EE 19c: best method to gather schema stats

Hi all,

our production database has a size of almost 4 TB and hosts the data of an external application. The provider of the external application recommends to gather the schema stats on a daily basis using the method "dbms_stats.gather_schema_stats(ownname => <schema name>, method_opt => 'FOR ALL COLUMNS SIZE AUTO', cascade => TRUE);". No need to explain that this method gathers the stats for all objects (tables and indexes) of the given schema, even if the statistics are still good enough or do not need to be newly gathered at all (because the data has not changed at all). This method -