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
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".
While doing this
I'm, trying to use v$transaction, It doesn't show which RBS is being used