Re: Delay when connecting to Oracle DB

Sounds like the first time you access the data it is not memory resident. The 2nd time it is. Although 4 to 5 minutes to wait is exessive. You need to ask yourself:
Is your db_block_buffers large enough?
Is your database spread over multiple disks? How many concurrent users do you have?
You may wish to trace the query to see what it is up to or select * from v$session_wait where sid = (the sid); while the query is running to see what it is waiting on.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com

"Deivnet" <davide_at_lsvapplication.it> wrote in message news:9vv10m$dda$1_at_fe1.cs.interbusiness.it...
> Hi,
> i think i have a problem with my application an Oracle 8.0.5 server on
> NT4Server.
>
> When with browser i'm calling an asp page that connect with the Oracle DB
i
> have for the
> first time a 10-15 seconds delay before the data appears, if i try another
> operation
> after immediately, data appears very fast (less then 1 sec).
>
> If i stop my navigation for 4/5 minutes and then retry to navigate my
> application
> data appears afetr 10-15 seconds.
>
> I don't understand what's the problem.
>
> Thanks Davide
>
>
> --
> .......................................
> Cavalleri Davide
> LSVApplication s.r.l.
> davide_at_lsvapplication.it
> 0372/450207
> .......................................
>
>
>
Received on Sat Dec 22 2001 - 05:12:11 CST