My Oracle Support Banner

RON (Repository Object Navigator) Navigation is Very Slow (Doc ID 1099484.1)

Last updated on MAY 01, 2018

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

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.