Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to dedicate a rollback segment to a session or a user ?
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