Re: Using Set Transation statement??

From: <steveee_ca_at_my-deja.com>
Date: Sun, 21 Jan 2001 21:43:18 GMT
Message-ID: <94fl5l$481$1@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 - 15:43:18 CST