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

Thread: OLTP question

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

    -John

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