How To Use Big Rollback segment for a particular transaction
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How To Use Big Rollback segment for a particular transaction

  1. #1
    Join Date
    Nov 2001
    Location
    Delhi
    Posts
    31

    Arrow 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

  2. #2
    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

  3. #3
    Join Date
    Dec 2002
    Posts
    9
    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.

  4. #4
    Join Date
    Dec 2002
    Posts
    9

    Wink

    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
  •  



Click Here to Expand Forum to Full Width