Documentation Center

Analyzing the database

After the import, you need to run a script that will create statistics used by the queries.

Before you begin

You first need to make sure that ORACLE_SID and ORACLE_HOME variables are set correctly (this is normally done during the ISOURCE user creation).

  1. Open a Command Prompt and set the following variable:

    Set ORACLE_SID=ISH

  2. Set ORACLE_HOME as follows:
    set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1

Procedure

  1. At a command prompt where the variables for ORACLE_SID and ORACLE_HOME are set, type:
    SQLPLUS /NOLOG
    CONNECT ISOURCE/isource
  2. Execute the FullAnalyze.sql script located on the CD:
    • CD-Package\Database\Common\Oracle\Tools\FullAnalyze.sql