Home » RDBMS Server » Server Administration » Rollback segment
Rollback segment [message #53982] Wed, 23 October 2002 00:43 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
hi
I got this piece from Oracle8 Documentation.
"An application can assign a transaction explicitly to a specific rollback segment. At the start of a transaction, an application developer or user can specify a particular rollback segment that Oracle should use when executing the transaction. This allows the application developer or user to select a large or small rollback segment, as appropriate for the transaction"
Just how is it possible to achieve this? What is the command?
Please email your reply

Report message to a moderator

Re: Rollback segment [message #53985 is a reply to message #53982] Wed, 23 October 2002 01:51 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
use:

set transaction use rollback segment [[RBS]]

Report message to a moderator

Previous Topic: Re: ocp sql & pl/sql - dumps
Next Topic: sys, system, internal?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 02:17:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.