Problem description
When trying to connect to a specific KB, Enlighten hangs.
Applicable in CAST Version
Release | Yes/No |
---|---|
8.1.x | |
8.0.x | |
7.3.x | |
7.2.x | |
7.0.x |
Action Plan
To accelerate opening of Enlighten: Add the following two options to the CAST INI-files:
In C:\Documents and Settings\<Your Windows Login>\Application Data\CAST\CAST\<CAST_VERSION>\Enlighten.ini
[Optimizer] Auto = 0
In C:\Documents and Settings\All Users\Application Data\CAST\CAST\<CAST_VERSION>\GloballySharedSettings.ini
[Global] ForceOptimizerChoose=1
- Updated statistics using Execute DBMS_UTILITY.ANALYZE_SCHEMA('your-schema', 'COMPUTE'); (this is for Oracle).
Relevant Input
Dump of the KB.
Notes/Comments
Related Pages