SQL> Select Count(1)
  2  From hxl.TB_HXL_LIST;
 
  COUNT(1)
----------
    100000
 
SQL> show user;
USER is "HXL"
SQL> Begin
  2    Dbms_Stats.Delete_Schema_Stats(Ownname => 'HXL');
  3  End;
  4  / 
 
PL/SQL procedure successfully completed.
 
SQL> Begin
  2    Dbms_Stats.Gather_Schema_Stats(Ownname          => 'HXL',
  3                                   Estimate_Percent => 2,
  4                                   Method_Opt       => 'for all indexed columns',
  5                                   Degree           => 2,
  6                                   Cascade => True);
  7  End;
  8  / 
 
PL/SQL procedure successfully completed.
 
SQL> Select a.num_rows,a.sample_size
  2  From Dba_Tables a
  3  Where  a.table_name In ('TB_HXL_LIST');
 
NUM_ROWS SAMPLE_SIZE
-------- -----------
   99521        4939