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?