-
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
-
-
I'm, trying to use v$transaction, It doesn't show which RBS is being used
Badrinath
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|