Re: Restrictions in the OTN downloadable version of 9i?

Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote:
> You don't say what the performance issues are. a description of what is
> going wrong (error message excessive response time) and some code snippets
> would help enormously.

Performance issues: the J2EE application is slow.

We just tried it using an 8i db installed on Win2k and it worked a lot faster (and the app received no timeout errors what it had previously got).

We have written a simple standalone java program that opens 10 concurrent connections in 10 threads via JDBC and runs a simple query in each of them fifty times. The program was tried against our db on linux that is having problems, another 9i installation on Solaris running the same db and two 8i's running different db's.

The result: Average response time for our linux 9i was from 10-141 secs (average 23 secs) and in every other machines 0-1 secs. We even tried it with the scott/tiger db (select * from tab) and the results were the same (low performance on linux).

Any help is really appreciated with tracking the problem down. We'd like to keep using Linux...

If you want to see the java test apps code or to know all the settings I can send them to you, just let me know...

Regards,
Peter

> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer

> ******************************************
Received on Wed Jul 03 2002 - 08:20:27 CDT