Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to dedicate a rollback segment to a session or a user ?

Re: How to dedicate a rollback segment to a session or a user ?

From: Dan Clamage <clamage_at_mime.dw.lucent.com>
Date: 1997/09/17
Message-ID: <01bcc349$a86b3b40$54110b87@clamagent>#1/1

Use the following procedure in package dbms_util:   procedure use_rollback_segment(rb_name varchar2);

nomail_at_nowhere.fr wrote in article <34190C04.5B74E516_at_nowhere.fr>...
> Problem:
> I would like to use a small RollBack Segment for svrmgrl and keep the
> big Rollback Segment to the other Session. That would allow me to
> monitor the v$session
> without using the production rollback segment.
>
> Unacceptable Solution:
> I Cannot use for all the session a ALTER TRANSACTION SET ROLLBACK
> SEGMENT because my software is written with ODBC an contain Thousand's
> of
> Query's which are automatically committed.
>
> Acceptable Solution:
> A way to a rollback to a dedicate a session (from login to logout)
> or
> A way to dedicate a rollback to a user
> or
> A way to forbid other transaction to use my rollback segment.
>
> I tried:
> I create an Private RollBack Segment witch doesn't appear in the
> init.ora (RollBack_Segment).
> To use it I Have to bring it online.
> I can use an ALTER TRANSACTION.
> But unfortunately Others transactions start to use it
>
> Any suggestions posted to this group will be appreciated.
>
>
Received on Wed Sep 17 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US