drop table test_038;

create table test_038 (col_1  number);

insert into test_038 (select level from dual connect by level <= 10000);

commit;

set autotrace on;

alter system flush buffer_cache;

select count(*) from test_038;

alter system flush buffer_cache;

begin
  dbms_stats.gather_table_stats(ownname => null
                               ,tabname => 'TEST_038');
end;
/

select count(*) from test_038;

set autotrace off;

SQL> drop table test_038;

Table dropped.

SQL> 
SQL> create table test_038 (col_1  number);

Table created.

SQL> 
SQL> insert into test_038 (select level from dual connect by level <= 10000);

10000 rows created.

SQL> 
SQL> commit;

Commit complete.

SQL> 
SQL> set autotrace on;
SQL> 
SQL> alter system flush buffer_cache;

System altered.

SQL> 
SQL> select count(*) from test_038;

  COUNT(*)
----------
     10000


Execution Plan
----------------------------------------------------------
Plan hash value: 2363355014

-----------------------------------------------------------------------
| Id  | Operation          | Name     | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------------
|   0 | SELECT STATEMENT   |          |     1 |     6   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE    |          |     1 |            |          |
|   2 |   TABLE ACCESS FULL| TEST_038 | 10000 |     6   (0)| 00:00:01 |
-----------------------------------------------------------------------

Note
-----
   - dynamic sampling used for this statement


Statistics
----------------------------------------------------------
          5  recursive calls
          0  db block gets
         47  consistent gets
         21  physical reads
          0  redo size
        411  bytes sent via SQL*Net to client
        396  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL> 
SQL> alter system flush buffer_cache;

System altered.

SQL> 
SQL> begin
  2    dbms_stats.gather_table_stats(ownname => null
  3                                 ,tabname => 'TEST_038');
  4  end;
  5  /

PL/SQL procedure successfully completed.

SQL> 
SQL> select count(*) from test_038;

  COUNT(*)
----------
     10000


Execution Plan
----------------------------------------------------------
Plan hash value: 2363355014

-----------------------------------------------------------------------
| Id  | Operation          | Name     | Rows  | Cost (%CPU)| Time     |
-----------------------------------------------------------------------
|   0 | SELECT STATEMENT   |          |     1 |     6   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE    |          |     1 |            |          |
|   2 |   TABLE ACCESS FULL| TEST_038 | 10000 |     6   (0)| 00:00:01 |
-----------------------------------------------------------------------


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
         23  consistent gets
          0  physical reads
          0  redo size
        411  bytes sent via SQL*Net to client
        396  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

SQL> 
SQL> set autotrace off;
SQL>