My Oracle Support Banner

Sql Queries Run Slower as OTM Domain User Compared to DBA.ADMIN User (Doc ID 2825814.1)

Last updated on DECEMBER 03, 2021

Applies to:

Oracle Transportation Management Cloud Service - Version 6.3.4 and later
Oracle Transportation Management - Version 6.2.0 and later
Information in this document applies to any platform.

Goal

 This note helps explain why SQL Queries (i.e. any data lookup in OTM) run slower as a normal OTM Domain User as compared to the same queries run by the DBA.ADMIN User.

Solution

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
Goal
Solution
 Explanation
 Testing query as DBA.ADMIN from SQL Execution Interface UI

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