ftp wrote:
>
> 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.
>
> --
Yes, tune Net8.
--
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Fri Oct 26 2001 - 14:35:20 CDT
