Oracle Performance Issue....

[mohit_sharan]

Hi,
I am tuning the Oracle Database. My database version is 8.1.7 , OS is windows 2000, Ram is 512 MB. We are running a Java Application in Tom Cat which is interacting with oracle Database. When both the application and database is in the same system the performace is very good. The LibraryCache Hit ratio,Dictionary cache hit ratio,Buffer cache hit ratio is above 99%. The redo log space requests is near to zero that is 1-3. I had configured the Java_pool_size also in the init.ora file.


But the problem is when we shift the application in different server having OS as windows 2000. The application performance degrades a lot. But the Hit Ratio and other value I am getting the same in the database side. We are using Oracle JDBC Thin Driver.

You can reply me in my personal id also mohit_sharan@yahoo.com

Please help me . Its very urgent.

Thanks and Regards.
Mohit.

[ggnanaraj]

Originally posted by mohit_sharan
But the problem is when we shift the application in different server having OS as windows 2000. The application performance degrades a lot. But the Hit Ratio and other value I am getting the same in the database side. We are using Oracle JDBC Thin Driver.

What problem in performance are u getting?
Any network errors? Maybe your system housing the application is overloaded.

[akhadar]

IT certainly issue with your network setup.

[slimdave]

... Buffer cache hit ratio is above 99% ...

Probably due to badly written SQL genrating too many logical I/O's. Check for the SQL's that generate the most LIO', and see what can be done to rewrite them.

You can reply me in my personal id also mohit_sharan@yahoo.com

Please help me . Its very urgent.

But not so urgent that you can be bothered to check back here though, presumably.