Re: Using Same connect by different process

In article <dcrowson.113.001110DE_at_amoco.com>, dcrowson_at_amoco.com (Dave Crowson) writes:
|> In article <CuMuL8.7xz_at_uunet!aadt> a363674_at_aadt.com (Shirish Kumar) writes:

|> You cannot guarantee that any given process uses any particular
|> rollback_segment, unless you reduce the database to having only one,
|> which wouldn't be a good idea.
|>

Actually, in Oracle7 you can use 'set transaction use rollback segment xxx'. This must be the first statement in the transaction, and will hold until the next commit or rollback. This is valid in version 6 as well I think, after a certain version (6.0.34 I think). But it isn't in PL/SQL 1.0, however. It is valid in PL/SQL 2.0.
|>
|> David Crowson Freelance Oracle Consultant (since 1983)
|> ---------------------------------------------------------
|> igotan_at_ombomb.demon.co.uk or weirdguy_at_cix.compulink.co.uk
|> ---------------------------------------------------------
|> "For my part, I travel not to go anywhere, but to go.
|> I travel for travel's sake. The great affair is to
|> move, to get down off this featherbed of civilisation
|> and to find the globe granite underneath and strewn
|> with cutting flints" : Robert Louis Stevenson
|>
|>
Received on Tue Aug 16 1994 - 19:45:56 CEST