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 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


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

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