Saturday, June 16, 2012

Relationship between sessions, processes and transaction in oracle 10g


Relationship between sessions, processes and transaction in oracle 10g

For increasing sessions parameter you should consider increasing processes and transactions parameter as well.
Below formula can be used to determine their values.
processes=x
sessions=x*1.1+5
transactions=sessions*1.1

E.g.
processes=100
sessions=115
transactions=127

Posted by at
Labels: , , ,

4 comments:

  1. UnknownSeptember 19, 2013 at 12:13 AM

    I like this article, it was very intresting and one of my friend told me that at hyderabad 123trainings provides bestOracle 11g DBA Online Training.. After trained in that institute he got placed in MNC company..

    ReplyDelete
  2. peterjohnAugust 21, 2015 at 7:00 AM

    This is one awesome blog article. Much thanks again.
    I really enjoy the blog.Much thanks again. Really Great.


    oracle online training
    sap fico online training
    dotnet online training
    qa-qtp-software-testing-training-tutorial

    ReplyDelete
  3. peterjohnAugust 21, 2015 at 7:02 AM

    This comment has been removed by the author.

    ReplyDelete
  4. peterjohnAugust 21, 2015 at 7:03 AM

    This comment has been removed by the author.

    ReplyDelete

Subscribe to: Post Comments (Atom)