My Oracle Support Banner

Workspace Delivery Is Very Slow / Literals Used (Doc ID 2537287.1)

Last updated on DECEMBER 19, 2019

Applies to:

Siebel Tools - Version 17.4 [IP2017] and later
Generic (Platform Independent)

Symptoms

On : 17.4 [IP2017] version, Siebel Config Dev

ACTUAL BEHAVIOR
---------------
Workspace deliver is very slow.
The process is very slow (7+ minutes). There are a number of queries with poor performance and this is where most of the time is spent.

SQL Statement Execute Time for SQL Cursor with ID 35C67178: 125.681 seconds *****
SQL Statement Execute Time for SQL Cursor with ID 35C67C40: 95.967 seconds *****
SQL Statement Execute Time for SQL Cursor with ID 35C691D0: 90.995 seconds *****
SQL Statement Execute Time for SQL Cursor with ID 35C66488: 36.279 seconds *****
SQL Statement Execute Time for SQL Cursor with ID 2FFBC100: 14.548 seconds *****
SQL Statement Execute Time for SQL Cursor with ID 35C67C40: 14.255 seconds *****

The queries are all related to IntObj repository tables, e.g. S_INT_FIELD, which contains 1.7 million records.

EXPECTED BEHAVIOR
-----------------------
SQL execute time should be much lower

STEPS
-----------------------
1. Create a new workspace
2. Import IO SIF
3. Deliver the workspace


Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.