Gather table stats

oracle.sql

declare
    v_owner varchar2(4000) := '?';
    type t_varchar2_tab is table of varchar2(4000);
    v_tables t_varchar2_tab := t_varchar2_tab(
        '?',
        '?'
    );
begin
    for i in 1..v_tables.count loop
        dbms_stats.gather_table_stats(
            ownname => v_owner, 
            tabname => v_tables(i),
            estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE, 
            method_opt => 'FOR ALL COLUMNS SIZE AUTO', 
            cascade => TRUE
        );
    end loop;
end;