Siebel Database Upgrade Guide > Performing the Siebel Incremental Repository Merge > Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x and 8.2.2.x (SIA Repository) >

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

This task is a step in Process of Performing an Incremental Upgrade of the Siebel Database from Siebel CRM Version 8.1.1.x and 8.2.2.x (SIA Repository). Use these tasks to run database checks on your specific database platform after your new repository has been created. The Upgrade Wizard pauses notifying you to execute RUNSTATS and then resume. At this point paused moment, the RUNSTATS command has to be executed.

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 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.