Re: Any experts here?

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)?

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.