Siebel Open UI, Tools, Scripting and EAI (MOSC)

MOSC Banner

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:

  1. Open tools.cfg.
  2. Search for the [Sample] section.
  3. 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.
  4. Change the two parameters to: -c256m -ch256m
  5. 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center