Re: Any experts here?

"ftp" <shyan_at_cse.cuhk.edu.hk> wrote in message news:9r6s9o$8bc$6_at_eng-ser1.erg.cuhk.edu.hk...
> 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!
>
> --

Five seconds is a meaningless measure and can be just anything, including a badly configured database. The Oracle defaults usually just *have* to be changed though it seems in latter release some parameters already have bumped. You don't provide any clue as to your config, and you seem already to know the solution.
However, as far as I am concerned, you have identified yourself already as the typical newbie, that refuses to read any manuals (including the jdbc manual, see your other post), and expect this group to help him with just *every* step, *every* line of code, etc. That's not the purpose of this group nor of .misc and of .tools. I strongly *urge* you to start reading.

Regards
Sybrand Bakker
Senior Oracle DBA Received on Wed Oct 24 2001 - 12:40:22 CDT