Hi.. There is only 1 transaction running in the entire database (A brand new dev db) and have 10 RBS, with 1 RBS a big one designed for batches.. We set the transaction for this RBS, and it accepted, but I cannot find the RBS being used.
I checked the v$rollstat for xacts > 0, but everytine it shows different USN (RBS id).. My questions :
How can I check to see which RBS my transaction is using
and secondly, when i query everytime there is a diff USN..
I was hoping that a RBS can span multiple transactions and 1 transaction cannot span multiple RBS..
Please confirm..
Thanks ST