RON (Repository Object Navigator) Navigation is Very Slow

(Doc ID 1099484.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Designer - Version 10.1.2.0.2 to 10.1.2.5 [Release Designer 10g]
Information in this document applies to any platform.

Symptoms

When we use Oracle Designer's RON (Repository Object Navigator) for investigating SQL statements we can find slowness in the query execution & it can be seen that Designer will use a completely different QEP (Query Execution Plan) when tracing is turned ON.

Example (SQL Statement):-

SELECT DISTINCT t.name, t.short_name, t.id
FROM i$sdd_object_versions o, sdd_folder_members m, rm_element_types t, i$sdd_wa_context w
WHERE o.irid = m.member_object
AND o.logical_type_id = t.id
AND w.object_ivid = o.ivid
AND w.workarea_irid = jr_context.workarea
AND o.wastebasket = jr_context.wastebasket

Changes

Issue appears to have been there since Installation, but only becomes apparent when Versioning turned ON & Objects Checked IN

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