Originally posted by sumit
I have executed a long statement. Suppose that has been associated with RB1.
1. depends on what you mean by this. If it is an UPDATE, DELETE, or INSERT statement, the previous post was correct. If it is a SELECT statement, the RBS will stay the same size until oracle can no longer get a consistent view of the data. Once that happens, you will get an ORA-1555.