Never thought of that. Well, you learn something new every day.
Thanks,
Jim
<steveee_ca_at_my-deja.com> wrote in message
news:94fl5l$481$1_at_nnrp1.deja.com...
> Hi,
>
> Jim's answer is far more common than my example but it so happens I used
> 'set transaction' last week to determine how much rollback a particular
> transaction was using by assigning it to a particular rollback segment..
>
> Steve
>
>
>
>
> In article <Wjua6.291055$U46.9298633_at_news1.sttls1.wa.home.com>,
> "Jim Kennedy" <kennedy-family_at_home.com> wrote:
> > You have a large transaction. That way you can assign it to a large
> > rollback segment. If you do not then you can generate a snapshot too
old
> > error.
> >
> > "JAP" <jasonperez_at_mindspring.com> wrote in message
> > news:94dlmj$ebh$2_at_slb7.atl.mindspring.net...
> > > I am reviewing PL/SQL for my OCP test. I understand the syntax of
<Set
> > > Transaction Use Rollback Segment random_label; > but I don't
understand
why
> > > it exists. Why would you us a Set Transaction? Does anyone have a
tangible
> > > real-world type example? The book uses a banking systems example
(Sybex;
> > > Oracle8i DBA SQL and PL/SQL study guide; page 183, Chip Dawes, Biju
Thomas).
> > >
> > > Thanks for the help.
> > > JAP
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sun Jan 21 2001 - 17:17:02 CST
