Re: High RBS usage during INSERT operation.

From: gazzag <gareth_at_jamms.org>
Date: 1 Nov 2006 02:16:05 -0800
Message-ID: <1162376165.872755.109020@m7g2000cwm.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

Oracle version? Received on Wed Nov 01 2006 - 04:16:05 CST

This message: [ Message body ]
Next message: Shailesh: "Composite index is not used for concatnated Date & Time fields?"
Previous message: Althalus: "DBMS_SCHEDULER external jobs failing but status of SUCCEEDED?!?!"
In reply to: vikram.kale_at_gmail.com: "High RBS usage during INSERT operation."
Next in thread: Niall Litchfield: "Re: High RBS usage during INSERT operation."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US