-
How To Use Big Rollback segment for a particular transaction
Dear Friends.
I had created a big rollback segment for a particular long running transaction.How to set that at time of that transaction this rollback segment be used.
Note: I want to use this segment only for that particular process.
Waiting for your reply.
Regards,
Imtiaz
Imti
Junior DBA
-
In the beginning of your transaction, do:
set transaction use rollback segment rbs_big;
If you plsql, i think you can use dbms_transaction.use_rollback_segment
www.cnoug.org
-
exactly what chao ping said:
you can set it at the transaction level OR
offline all the other RBS's and start your transaction, of course this will have negetaive eefects if done during business hours, so this shoulod be scheduled.
-
when you offline the other RBS's keep RBS_BIG online naturally
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
|