Re: "X commits per minute": is there an absolute threshold ?

Sebby <sebastien.rigaud_at_b-rail.be> wrote:
>Hi,
>I'd just like to know if you can say that from a certain
>level, you have too many commits per minute (could it be
>600/mn, or 5000, or 10000/mn ?), with no regard as to the
>values of yours parameters etc. whatsoever.
>
>And if no, what does this number depend on (size of rollbacks,
>init.ora parameters etc.) ? I mean if you want to ensure that
>from now on your DB will address 5000 commits/mn when you
>previously had only 200, what should you modify ?

No, it depends mostly on what your transactions involve. I've seen databases with up to 200,000 transactions/minute (sustained).

Your second question boils down to "how do I tune an Oracle database?", for which you need to start reading books. Oracle's own "Concepts" and "Performance Tuning" manuals are available for no cost from http://tahiti.oracle.com/ and are the best place to start.

-- 
Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/