Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle + java = slow?

Re: oracle + java = slow?

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 07 Oct 2002 15:50:10 GMT
Message-ID: <3DA1AD13.5B4803E1@exesolutions.com>


"Géry" wrote:

> String sourceURL = "jdbc:oracle:thin:@(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:@server1.info.bt.co.uk:1521:oracle";
> but this did not work and the above is the work arround.
>
> many thanks in advance

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

I would suggest that you start at the beginning and work forward. If you are going to post here again it would be helpful if you provided even the minimum 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
  4. Oracle database version and edition
  5. Amount of RAM dedicated to the Java Pool, etc.

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US