Thanks for the responses.. It makes sense since I am starting a transaction and when commited, it is not using the RBS anymore. So, If I want to use the same RBS for my entire processing which includes close to 15 programs/scripts, then I should literally edit all the scripts to include this RBS at the beginning and after every commit..
Secondly, My largest RBS is 2GB and is optimal is 10 extents or 500MB. What is the use of this optimal and how is my optimal impacted, if my transaction does not cross my optimal and does cross my optimal..
Thirdly, If I have frequent commits, what happens to optimal if I continue with the same RBS and if I dont continue with the RBS??
Fourth, How should the 2GB RBS be configured if the table would get more than 2GB data. I mean how should optimal be configured and what should be the frequency of commits for the success of the transaction??
Thanks.. ST