Re: intermittent commit on insert ?

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 4 Jun 2002 22:27:26 +0100
Message-ID: <3cfd30be$0$8506$cc9e4d1f@news.dial.pipex.com>

"Chuck" <chuckhNOSPAM_at_softhome.net> wrote in message news:adj4tq$116qbh$1_at_ID-85580.news.dfncis.de...
> Why would smaller commits increase the log volume? You're still inserting
> the same amount of data into the table. The miniscule amount of log space
to
> hold the commit records isn't even worth mentioning.

No-one said it would change the log volume. Redo isn't the issue here. Undo is.

>
> I think everyone is missing the point here though - how much RBS space is
> consumed by inserts? It's tiny! The space required to insert 1m rows is
> problably around 10m. If you're RBS can't afford a 10m RBS you've got some
> serious space issues.

The point is that the rollback system will suffer under artificially high numbers of transactions. You commit at the end of a transaction and the DBA's job (pain that it is) is to size rollback segments appropriately.

--
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Tue Jun 04 2002 - 16:27:26 CDT