Current Rollback Segment?

Hi,

How do I see , which is the current rollback segment my session is using?

If I have set the transaction to use one rollback segment, till when is it valid ?
When I issue commit/rollback command will the rollback segments go back to the default rollback segment
Badrinath

You can check from v$tansaction which transaction is using what RBS.
The RBS that is set thru SET TRANSACTION is used till you issue a commit/rollback.
There is nothing like default RBS.

Thanks for that info.

For batch deletes:

I set the rollbacksegment to a large one ("Large_RBS").

I run a procedure to delete the records for a table, and still to be on a safer end, I commit at the end of 1000 records.(inside the procedure)

Does this stop using the "Large_RBS".

Badrinath

While doing this

Yes.

I'm, trying to use v$transaction, It doesn't show which RBS is being used

Badrinath