Re: Can dropping RBS cause problems?

I had a bit of a problem here. For dropping a rollback segment I put if offline first. Some transaction was still pending offline. Because the transaction was not killed by me before, it tried to extend its slot which it used within that rollback segment. Because this RBS was pending offline, no extension was possible, therefore the transaction rolled back (which was ugly as it took some hours to roll back that mammoth).

So check if you have active transactions (v$transaction.status = 'ACTIVE') that will extend their slot within the RBS in question. You can find this by querying v$transaction.xidusn which points to dba_rollback_segs.segment_id which in turn will tell you the segment_name you want to set offline.

Martin

"C. Payer" wrote:
>
> As long as I work with Oracle I often heared the question, if it could cause
> problems dropping rollback segments during normal workload (e.g. for the
> need of bigger RBS or in a different tablespace). I never had problems doing
> this, but in the technical books there is no answer to this question.
>
> But, what exactly happens with the data in the dropped RBS? Does anybody
> know an exact answer?
> Thanks, Claudia
Received on Sun Sep 05 1999 - 08:33:57 CDT