Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Which rollback segment am I using NOW?

Which rollback segment am I using NOW?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 28 Oct 1999 05:54:00 GMT
Message-ID: <3818e51e.2869135@172.16.7.5> 





Hello,



If I connect to database, and do some insert,update,delete.
If I don't issue commit or rollback yet,
the before image will be stored in one of the online rollback segment.
I have RBS1,RBS2,RBS3,RBS4 and SYSTEM -- 5 online rollback segments,
How could I know which one the transaction is using now?



ps.I don't need to use SET TRANSACTION USE ROLLBACK SEGMENT.
Thanks for your reply.



Violin.


violin.hsiao_at_mail.pouchen.com.tw
Received on Thu Oct 28 1999 - 00:54:00 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US