My Oracle Support Banner

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 APRIL 30, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.