SQL Performance (MOSC)

MOSC Banner

12.2 : Execute vs Fetch => SQL Developer

edited Mar 8, 2020 6:37PM in SQL Performance (MOSC) 2 commentsAnswered

Hello,

A user complains about a query (SELECT) which takes 15 min instead of 5 sec usually.

I re-executed the query on SQL Developer (Oracle 12.2).

Here is the behavior of the query execution :

1 min to display the first 50 rows (SQL Developer Configuration).

15 min to display the rest of the rows  (800 in total) by doing CONTROL-A in SQL Developer results window

Is this normal behavior?

Is this a performance issue at runtime or fetch level or both?

Thank you.

GD.

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