Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> High RBS usage during INSERT operation.

High RBS usage during INSERT operation.

From: <vikram.kale_at_gmail.com>
Date: 1 Nov 2006 00:21:40 -0800
Message-ID: <1162369300.477840.240760@e3g2000cwe.googlegroups.com> 





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
Received on Wed Nov 01 2006 - 02:21:40 CST












Original text of this message













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