Re: Help: Too much rollback info

your indexes are the problem here.

Joe Sath wrote:

> We are using oracle 8173.
>
> In Jason Couchman's book, "DBA Cert. Exam Guide",
> it says,
>
> insert(stores new ROWID in rollback segment only),
> update (stores ROWID plus old column value), and
> delete (stores ORWID and all row/column data).
> So if your transactions primarily insert data, your rollback segments
> would be smaller than....
>
> But I notice that, during inserting, importing data, we are using much
> bigger rollback segments.
>
> For instance, for a table with 11 partitions, we are only updating one
> column of one Partition, the highwater mark of the partition only takes
> 200m, but during the update, rollback grows to 1.1G. And there is only
> one session on the database.
>
> Is it the normal behaviour or is it a bug?
>
> Thanks for your reply
>
>
>
>
>
>

-- 
hth,
Stan