Ron Reidy <rereidy_at_indra.com> wrote:
> 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!
>>
>> --
> What makes you think it is the login time? Have you timed all of the
> steps (including login time)?
I System.out.println() immediately after login and find that the login
time is about 5 seconds.
Can I shorten the login time?
> Creation of tables is very time consuming, as is dropping tables. For
> your insert statements, are you using array processing? Bind variables?
> If you don't know what the above are, read the Oracle development docs
> and the Java docs, and the generic JDBC docs.
> --
> Ron Reidy
> Oracle DBA
> Reidy Consulting, L.L.C.
--
Received on Fri Oct 26 2001 - 13:06:50 CDT