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 (SIA Repository), 8.2.2.x, 15.x, and 16.x >

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 (SIA Repository), 8.2.2.x, 15.x, and 16.x. 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.

Siebel Database Upgrade Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.