How To Use Big Rollback segment for a particular transaction
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.
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
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
Click Here to Expand Forum to Full Width