RON (Repository Object Navigator) Navigation is Very Slow

(Doc ID 1099484.1)

Last updated on MAY 01, 2018

Applies to:

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


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.short_name,
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 =
AND w.object_ivid = o.ivid
AND w.workarea_irid = jr_context.workarea
AND o.wastebasket = jr_context.wastebasket


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


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