Re: High RBS usage during INSERT operation.

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: 1 Nov 2006 04:24:59 -0800
Message-ID: <1162383899.743520.35240@e3g2000cwe.googlegroups.com>

vikram.kale_at_gmail.com wrote:
> Hi
>
> I have noticed that rollback segment usage is 7 times more compared to
> the actual table size. The table size is 350mb whereas the transaction
> involving INSERT statement has taken 2500mb. Any thought?? (no indexes,
> only data)
>
> regards,
> VK

Well my first thought was indeed indexes, and I'd certainly check that - apart from anything else a table with no index (not even a pk) sounds suspicious to me. It would also be interesting to see how you are doing the insert - is it a bulk operation or is it a whole bunch of single row operations perhaps with with intermediate commits? Received on Wed Nov 01 2006 - 06:24:59 CST