SQL Execution and Initial Fetch Completed in Less than 1 Second but SQL Fetch Time Taking 12 to 30 Seconds (Doc ID 2269704.1)

Last updated on MAY 31, 2017

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

----------------------

SQL Execution and initial fetch completed in less than 1 second but SQL fetch time taking up to 12 seconds. In the AOM log file , the following can be seen:

EXPECTED BEHAVIOR
-----------------------
Fetch should not last 12 secs.

Cause

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