-
Hello:
If you have 10 RBS in total and you have all 10 RBS assigned to 10 transactions which are not ended yet, and if a 11th transaction is started what happens? Does it mean that if you have 10 RBS, you can only run 10 transactions at a time??
An update or an insert starts a transaction right??
Thanks, ST
-
u can have multiple transactions on one RBS
-
transactions are just spread almost equally between all RBS ... if you look at XACTS in V$ROLLSTAT, you'll see how many transactions are assigned to each rollback segment ...
-
Originally posted by st2000
An update or an insert starts a transaction right??
A delete also requires rollback, not to mention DD changes requiring rollback space eg create/alter DB objects.
-
Even in INSERT required a RBS.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|