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).
- Open a Command Prompt and set the following variable:
Set ORACLE_SID=ISH
- Set ORACLE_HOME as follows:
set ORACLE_HOME=c:\oracle\product\12.1.0\dbhome_1