OraFAQ Forum: Server Administration » SET TRANSACTION USE ROLLBACK SEGMENT

Home » RDBMS Server » Server Administration » SET TRANSACTION USE ROLLBACK SEGMENT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SET TRANSACTION USE ROLLBACK SEGMENT [message #23163]

Wed, 20 November 2002 02:48

fareeda@pspl.co.in
Messages: 4
Registered: October 2002

Junior Member

Is it possible to lock a particulat rollback segment when I use the above set transaction statement?

Basically, I would like to always use a particular rollback segment and not allow anyone else to use it when I am using it.

Report message to a moderator

Re: SET TRANSACTION USE ROLLBACK SEGMENT [message #23179 is a reply to message #23163]

Wed, 20 November 2002 07:48

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yes.
use the command.
Make the RBS as PRIVATE.

Report message to a moderator

Are U sure Mahesh ? [message #23181 is a reply to message #23179]

Wed, 20 November 2002 08:02

B
Messages: 327
Registered: August 1999

Senior Member

PRIVATE/PUBLIC is for OPS...

PUBLIC means that for a multi-instance database, any instance can use the rollback segment.

PRIVATE, which is the default, means only the instance which has the rollback segment's name in its ROLLBACK SEGMENTS clause of its INIT.ORA file can use the rollback segment.

So i think there is no way to prevent a user to use an online RBS.

Report message to a moderator

Re: Are U sure Mahesh ? [message #23182 is a reply to message #23179]

Wed, 20 November 2002 08:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

yes u r right.
but i am not very sure about.
[i][b]So i think there is no way to prevent a user to use an online RBS[/i][/b]
there is something that i have never tried before.
what if i set 
transactions_per_rollback_segment = 1
and proceed?

Report message to a moderator

Re: SET TRANSACTION USE ROLLBACK SEGMENT [message #23433 is a reply to message #23179]

Mon, 09 December 2002 04:17

fareeda@pspl.co.in
Messages: 4
Registered: October 2002

Junior Member

any updates on this?

Report message to a moderator

Previous Topic:	Kill Session
Next Topic:	Enterprise versus Standard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:58:30 CDT 2024