Oracle Forms (MOSC)

MOSC Banner

Time spent for database select and record fetching during a form query?

edited Nov 26, 2018 4:30AM in Oracle Forms (MOSC) 3 commentsAnswered

Hi,

We have problems with some queries running slow when executed from Oracle Forms, while this slowness cannot be reproduced executing the same query directly in database (from TOAD).


Trying to diagnose this, i added some logging into Forms, and the results are like that:

21.11.2018 12:17:33.064043 pre-query

21.11.2018 12:17:54.367740 post-select

21.11.2018 12:20:47.738896 post-query, recno=1

As far as my understanding has been:

  • a) the time difference between lines 1 and 2 (21 sec) should correspond to the actual database query (this is roughly consistent with the time of executing the query in TOAD);
  • b) the time difference between lines 2 and 3 (almost 3 min) should correspond to fetching resulting records from database to Forms?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center