My Oracle Support Banner

Performance issue when creating relationships using TCA API (Doc ID 386479.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Trading Community - Version 11.5.10 to 11.5.10.3 [Release 11.5]
Information in this document applies to any platform.
API HZ_RELATIONSHIP_V2PUB.create_relationship package

Symptoms

1. When creating relationships using TCA API, you find a performance issue with HZ_RELATIONSHIP_V2PUB.create_relationship package.

2.The most expensive SQL statement  in the trace file is :

Select level, relationship_id, subject_id, object_id, status, start_date,
end_date, subject_table_name, subject_type
From
hz_relationships where relationship_id <> :b3 start with object_id = :b7 and
object_table_name = :b6 and object_type = :b5 and direction_code = 'p' and
relationship_type = :b4 and relationship_id <> :b3 and start_date <= :b2
and end_date >= :b1 and status='a' connect by object_id = prior subject_id
and object_type = prior subject_type and object_table_name = prior
subject_table_name and direction_code = 'p' and relationship_type = :b4 and
relationship_id <> :b3 and start_date <= prior end_date and end_date >=
prior start_date and start_date <= :b2 and end_date >= :b1 and status='a'

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.