after dbm_stats sample_size same as num_rows

dbms_stats.gather_table_stats(

                                                                ownname => obj_rec.owner,
                                                                tabname => obj_rec.table_name,
                                                                method_opt =>
                                                                'for all indexed columns size 1 ',
                                                                estimate_percent => dbms_stats.auto_sample_size,
                                                                cascade => true,
                                                                block_sample => true,
                                                                degree => dbms_stats.auto_degree);