Executing the RUNSTATS Command on Oracle Database During the Pause Following New Repository Creation

This task is a step in Process of Meeting Requirements for an Incremental Repository Merge. Use these tasks to run database checks on your specific database platform after your new repository has been created. The Upgrade Wizard pauses and notifies you to execute the RUNSTATS command and then resume. Execute RUNSTATS as described in the procedure that follows.

To execute the RUNSTATS command on Oracle Database

• 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 SQL*Plus 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.