Connect to SQL plus, and execute the following command:
EXEC DBMS_STATS.gather_schema_stats (ownname => 'table_owner_name
', cascade =>true,estimate_percent => dbms_stats.auto_sample_size);
Example:
Invoke sqlplus from the Oracle client.
SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 21 19:21:46 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL> EXEC DBMS_STATS.gather_schema_stats (ownname => 'ORAZQ108', cascade =>true,estimate_percent => dbms_stats.auto_sample_size);
PL/SQL procedure successfully completed.