Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: FIRST JAVA SELECT VERY SLOW
This is most likely because the first select statement in your cgi program
(or any SQL based program/script) is having to go out to disk to get the data
requested by the first select. The next select statement in the program will
probably have many of the needed data blocks already in the SGA that were
placed there by the first statement so it does not have to go out to the disk
as much. In other words, your second and following select statements will
have a higher cache hit ratio than the first statement.
Regards
Ron Bogdanoff
Sr. Software Engineer
Digital Market Inc.
In article <369620F0.D3F10F2A_at_in.fh-merseburg.de>,
Torsten Schuelert <torsten.schuelert_at_in.fh-merseburg.de> wrote:
> We have Oracle 8.04 / Windows NT 4.0 and Oracle Webserver 2.0.
> The acces from Webbrowser (IE, Netscpae or Opera) is slow.
> We found out that the first "select" instruction in a java-cgi-program
> is slower than all the others in this program.
> It does not depend on complexity of the select instruction or the
> dimension of the database.
>
> Any ideas?
>
> Thanks for everything.
>
> Torsten
>
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 15:47:05 CST
![]() |
![]() |