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

From: Yong Huang <yong321_at_yahoo.com>
Date: 31 Oct 2002 09:54:05 -0800
Message-ID: <b3cb12d6.0210310954.1080caef@posting.google.com>

sebastien.rigaud_at_b-rail.be (Sebby) wrote in message news:<5bc80fe2.0210310019.4338db36_at_posting.google.com>...
> 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 ?

Modify the code! So that it doesn't commit that often.

If you really need many commits per second, optimizing logfile writing may be the most effective (use raw disks or a good filesystem e.g.). Also make sure log_buffer is not too big.

Yong Huang Received on Thu Oct 31 2002 - 11:54:05 CST