Is there any correlation between Transaction rate and No. of concurrent users ... how can I get these rate with details, another problem I have is when you use JDBC I think we have just one concurrent user Java client and can not find any individual which use connection pool , any idea how can I do that ?
An ounce of prevention is worth a pound of cure
Look in v$sysstat and v$sesstat. In the NAME column
look for 'user commits' and 'user rollbacks' to get an
idea of the numer of transactions and how fast they come.
These numbers increase until the database restarts, then
the numbers start over.
Click Here to Expand Forum to Full Width