Re: oracle + java = slow?

"Géry" wrote:

> > 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.
> All I am saying is: where do you look if you encounter that sort of problem.
> With regards to my implementation, well, it looks pretty straightforward to
> me.
>
> >
> > 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
> p4 1ghz+ RAM 1gb+
> > 2. Network
> LAN
> > 3. Operating system and version
> WIN2k server (for the Oracle server) win 2k for the client machines
> > 4. Oracle database version and edition
> Oracle 9
> > 5. Amount of RAM dedicated to the Java Pool, etc.
> ?

1. Ok
2. Not good enough. Everybody's got a LAN. Check with your network administrator and work with that person to make sure you have things configured properly.
3. With current patch sets?
4. Not good enough? Is it 9.0.1 Standard Edition or 9.2.0 Enterprise Edition. It makes a difference
5. This is a big deal. You need to know the parameters used to create the spfile. Check with your DBA.

Daniel Morgan Received on Mon Oct 07 2002 - 12:08:43 CDT