Re: Any experts here?

From: Steve Guilford <sguil4d_at_pacbell.net>
Date: Thu, 25 Oct 2001 03:10:42 GMT
Message-ID: <SoLB7.3017$P5.931788841@newssvr21.news.prodigy.com>

Put some 'print' statements to printout a timestamp 'before' and 'after' each major step in your program (i.e. Login, Create, Insert etc...). Then you can see where the time is being spent.

Process creation always takes time anyways. 5 seconds doesn't seem so bad...

ftp wrote:

> I have installed Oracle8i in Windows 2000.
> I have written a test program to connect to the database by JDBC OCI
> driver.
> The job of my test program is to create a table, insert two records into
> the table, select * from the table, print the data out and then drop the
> table.
> I find that it takes about 5 seconds to run the program. I guess that this
> is due to the long login time.
> How can I shorten the time to login to Oracle?
> Where can I configure the Oracle in order to shorten the login time?
> I'm a beginner to installation of Oracle, please answer me step by step if
> possible.
>
> Thank you very much.
>
Received on Wed Oct 24 2001 - 22:10:42 CDT