DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: OLTP question

  1. #1
    Join Date
    Nov 2000
    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

  2. #2
    Join Date
    Nov 2000
    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.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.