Re: Performance, new info!

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:0oeh1vk7i5r2inen6fv4qr269hk1n81lr6_at_4ax.com...
> On Sun, 05 Jan 2003 18:14:59 GMT, "Stephan" <test_at_test.com> wrote:
>
> >
> >Can someone tell me what the reason can be?
>
>
> Please stop playing games and submitting riddles.
> You have run *exactly* the same query 11 times, and you post the
> statistics for all 11 queries, without *one* single EXPLAIN PLAN.
> And the only difference between all those queries is that the last
> time, the FETCH took longer. What should this group do about this?
> Give your server a slam?

Yes, you are right: I ran the same query 11 times and the performance of each run is very variable.

You -as a specialist- write: "And the only difference between all those queries is that the last time,
the FETCH took longer. What should this group do about this?" Maybe you cannot imagine, but I just ASK, maybe someone can point me to a direction? For example: change some init.ora parameter. Maybe there's someone who knows possible reasons for long FETCH times?

I am not playing games, just trying to give as much relevant information as needed.

Best regards
Stephan

>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Mon Jan 06 2003 - 03:02:18 CST