Siebel 8.1.1.11 Local Tools Compile Hangs, Slow SQL around Integration Objects, Full Compile Very Slow Performance when Compiling from Local Database. (Doc ID 1904272.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.1.1.11.5 [IP2013] and later
Information in this document applies to any platform.

Symptoms

Siebel 8.1.1.11 Local Tools Compile Hangs

A full compile on the local database sse_data.dbf has two queries that take 600 seconds and 1200 seconds respectively. These queries use the Repository tables for Integration Objects. The overall cost to the compilation process is at least 30 mins wasted.

The full srf compile performance is ok if compiled against the server database instead of the local developers database.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms