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

Thread: Transactions

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    What is the number of transactions supported by oracle8i and oracle9i in a second?

    Thanks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    It purely depends upon the hardware setup.
    I read 1 to 5000 per second.

  3. #3
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    also transactions_per_second can be set in the init.ora file.
    siva prakash
    DBA

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by prakashs43
    also transactions_per_second can be set in the init.ora file.

    That parameter is perhaps planned for Oracle release 12i, when the database will be so fast that you'll actually want to limit its speed!!!

    Seriously, there is no such parameter. You probably ment TRANSACTIONS_PER_ROLLBACK_SEGMENT ....

    How many transactions can Oracle database handle? There are at least two parameters missing in that question. First one, as Tamil allready pointed out, is what computer system are we talking about (HW + OS). The second one is, what type of transactions are we talking about. You know, on a given system transaction A could be executed in miliseconds, while transaction B on the same system can last for hours. If you are interested in lab results on precisely described systems with standardised type of transactions, visit the official benchmark site http://www.tpc.org
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Juriy u did mistake: I thing that will be possible only in Oracle 13i.
    Just because today is ...

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