Full compile with Sample DB: ensure the cache is large enough
Dear Tools community,
The Sample DB is rarely used as a source for a full compile; however, if you plan to do one, you will want to ensure that the database engine's cache size is large enough. Here is how you do this:
- Open tools.cfg.
- Search for the [Sample] section.
- The ConnectString parameter in this section has two parameters (among others): -c and -ch. These parameters define the initial cache size and the maximum cache size. The default settings are: -c40m and -ch60m.
- Change the two parameters to: -c256m -ch256m
- Save tools.cfg.
Background:
With the default settings, running a full compile with a Siebel 15.0 Sample DB causes Tools to hang when executing a particular SELECT statement. After enlarging the cache size, the full compile successfully finishes within the usual time frame.