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

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Wed, 03 Jul 2002 12:24:51 GMT
Message-ID: <n2CU8.4$%w6.238@se2-cb104-9.zrh1.ch.colt.net>

<peter.peltonen_at_iki.fi> wrote:
> We have downloaded the Oracle 9iR1 from http://otn.oracle.com and are
> having performance issues with our J2EE app using the db via JDBC. We
> were wondering:
>
> Is the 9i database server somehow limited that is downloadable from OTN?

No, it is not.

The information provided shows no relevant information from v$session, v$process (at least that there is no lockwait). Performance issues is a very wide subject, it starts with a look at your SQL code and ends with a look at the hardware. And there is a lot between! I'd start reading the Oracle tuning guide (http://technet.oracle.com) or even with the concepts guide.

If you have specific questions, come back here.

Regards,

Knut Received on Wed Jul 03 2002 - 07:24:51 CDT