Re: oracle + java = slow?

"Géry" wrote:

> String sourceURL = "jdbc:oracle:thin:_at_(DESCRIPTION = (ADDRESS_LIST =
> (ADDRESS = (COMMUNITY = server1.info.bt.co.uk) (PROTOCOL = TCP) (Host =
> server1) (Port = 1521) ) ) (CONNECT_DATA = (SID = oracle)
> (SERVER=DEDICATED) ))";
> databaseConnection = DriverManager.getConnection(sourceURL,usr,psw);
>
> The above two lines of java code work but the response is so slow. It takes
> perhaps fifteen minutes to connect. My personal felling is that there is a
> problem with Oracle itself on the server. I believe so because other
> applications connecting to the same Oracle database have similar problems.
> Is there a way to check the Oracle server. I tried logging in Oracle console
> and the net manager, I cannot see anything wrong but frankly I do not know
> where to look.
>
> PS: I know ordinarily the first line should be something like:
> String sourceURL = "jdbc:oracle:thin:_at_server1.info.bt.co.uk:1521:oracle";
> but this did not work and the above is the work arround.
>
> many thanks in advance

[Quoted] [Quoted] There is a problem. No question about that. But how you can leap lightyears to [Quoted] [Quoted] come to the conclusion that because it takes 15 minutes there is a problem with [Quoted] Oracle is truly amazing to me. You must know that if it took more than a few [Quoted] seconds for most people this usenet group would be full of complaints. And since [Quoted] it isn't the problem clearly rests with your implementation.

[Quoted] I would suggest that you start at the beginning and work forward. If you are [Quoted] going to post here again it would be helpful if you provided even the minimum [Quoted] amount of information so that someone could help you. Here are a few suggestions:

1. Hardware and RAM
2. Network
3. Operating system and version [Quoted]
4. Oracle database version and edition [Quoted]
5. Amount of RAM dedicated to the Java Pool, etc.

Daniel Morgan Received on Mon Oct 07 2002 - 17:50:10 CEST