Re: How can I get PL/SQL to use a specific RB seg

Hi !

This is my suggestion:

I guess while your transaction T1 is running another transaction T2 starts and updates some data T1 accesses, storing the old values in T2's rbs. When T1 shall read the value, it tries to read the value at the time T1 started, reading from T2's rbs.
So the weakness is T2's rollback segment. Increase it, or, if the 'Optimal' size parameter is low, increase that one, because, when T2 is finished, the rbs size is adjusted back to Optimal Size, if this is set. If its not set, set it to something. Try and err...

Mark Rosenbaum wrote:

> Thanks for the response. That is where the problem is. It is a
> PL/SQL program and the snap shot too old is comming from a different
> rbs. I'm posting for an other dba so I don't have exact details
> but he is very good and has tried to follow the Oracle example
> with no luck. The obvious alternative is to increase all the
> RBSes but that is easier said then done with the outsource that
> they currently have. Any help would be greatly appreciated.
>
> tia
>
> mjr

--
Njål A. Ekern
n.a.ekern_at_usit.uio.no