session 1 > 

SQL> conn sys as sysdba
Enter password:
Connected.


SQL> set timing on
SQL> exec dbms_stats.gather_schema_stats ( 'HR' );

PL/SQL procedure successfully completed.

Elapsed: 00:00:06.81


session 2 >

SQL> create table big_table as select * from all_objects where 1 = 2;

Table created.


SQL> set timing on
SQL> insert into  big_table  select * from all_objects
  2  union all
  3  select * from all_objects
  4  union all
  5  select * from all_objects
  6  union all
  7  select * from all_objects
  8  union all
  9  select * from all_objects
 10  /

194940 rows created.

Elapsed: 00:00:47.61
SQL>

During analyze process "big_table" status.

SQL> select table_name,num_rows,blocks
  2  from dba_tables
  3  where owner = 'HR';

TABLE_NAME                       NUM_ROWS     BLOCKS
------------------------------ ---------- ----------
REGIONS                                 4          5
COUNTRIES                              25
LOCATIONS                              23          5
DEPARTMENTS                            27          5
JOBS                                   19          5
EMPLOYEES                             107          5
JOB_HISTORY                            10          5
TAB1                                    5          5
TAB2                                    4          5
BIG_TABLE                               0        558

10 rows selected.

Elapsed: 00:00:01.64


After processing and after complete insert operation.

SQL> exec dbms_stats.gather_table_stats('HR','BIG_TABLE');

PL/SQL procedure successfully completed.

Elapsed: 00:00:06.17
SQL> select table_name,num_rows,blocks
  2  from dba_tables
  3  where owner = 'HR' and table_name = 'BIG_TABLE';

TABLE_NAME                       NUM_ROWS     BLOCKS
------------------------------ ---------- ----------
BIG_TABLE                               0       2764

Elapsed: 00:00:00.00