Re: analyzing db for performance bottlenecks

You didn't mention the type of transaction (insert/update/delete/select), if

triggers/packages were involved, if the machine itself was CPU bound etc.

Oracle out of the box comes with many tools for tracing down such problems.

You could be dealing w/ locking (the java servers locking the same rows - utllockt)
concerns, sorting concerns, redo issues, archive targets, have you collected stats
on NT yet .....

start w/ bstat-estat

guy
jmanju_at_my-deja.com wrote:

> Hi,
>
> We are doing performance tests on our server and it looks like the
> bottleneck is database. We are using oracle 8.1.6 on solaris or NT with
> java/corba server and the connection to database is using JDBC. On
> solaris, one java server can handle 1800 requests/minute and increasing
> the number of servers to 4 (all of them connecting to the same db)
> increases the total number of requests handled by the system. But after
> that point, increasing the number of java servers does not help. This is
> the case even if we move each server to its own machine and the db alone
> on one machine.
>
> Do you know of good tools to analyze the database to see where the
> bottlenecks are or tools to help tune a database? We have checked for
> disk contention and shared memory so far and they seem fine. Thank you,
>
> Manju.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
  Received on Tue Sep 19 2000 - 15:49:12 CDT