APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why does a query respond in two different times, while nothing changes.

bma66Jan 23 2018 — edited Jan 23 2018

hi,

i create view like

"select col1,col2,col3 from table where user=v('APP_USER')"

when run query first time

"select count(*) from view "

the time is 0.02 s but

next I will run the same query again

"select count(*) from view"

Time changes to 8 seconds,Again when compiling it ,Time is 0.2 seconds and next query is 8 second.

why?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2018

Added on Jan 23 2018

#apex-discussions, #performance

4 comments

389 views