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

Thread: setting the transaction parameter

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Cool

    I would like to set the transaction parameter in my initSID.ora file. Is there a way to find out how to determine/calculate the correct number to specify in the initSID.ora file?

    e.g How would I know if I have to set it to
    transactions= 200,
    transactions=300,
    400,etc

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    This number is the maximum number of tracsactions you can have in the database at one time. If you don't set it, Oracle will set it as :

    (1.1 * SESSIONS)

    And sessions is calculated by Oracle as...

    (1.1 * PROCESSES + 5)

    -John
    John Dorlon
    www.ezsql.net
    john@ezsql.net

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