My Oracle Support Banner

Performance Issues With AutoREST Feature Enabled Using ORDS (Doc ID 2405788.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle REST Data Services - Version 17.4.1 and later
Information in this document applies to any platform.

Symptoms

Performance issues when using the  AutoREST feature of ORDS.
ORDS is taking seconds (3-6) to perform a request on a basic table that contains 12 columns and only 8 rows.

It woks perfectly fine if we create the endpoint manually, responding in less than a second.

Example

----------
ORDS executes the following request that takes time in JDBCTabularResources.generatorMetadata :

 

SELECT t.table_name, o.object_alias ALIASING, o.type OBJECT_TYPE, t.column_name, t.data_type, t.data_type_owner, t.typecode, t.data_precision, t.data_scale, t.char_length, t.char_used, (SELECT count(*) FROM user_cons_columns cc, user_constraints c WHERE c.constraint_type = 'P' AND cc.table_name = t.table_name AND cc.column_name = t.column_name AND c.constraint_name = cc.constraint_name) is_pk_field FROM user_tab_columns t, user_ords_enabled_objects o, all_types td WHERE t.table_name = o.parsing_object AND o.id = :1 AND td.owner(+) = t.data_type_owner AND td.type_name(+) = t.data_type order by t.column_id

 

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.