OraFAQ Forum: Server Administration » Can I set a massive delete transaction not use roll back segment

Home » RDBMS Server » Server Administration » Can I set a massive delete transaction not use roll back segment

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

Can I set a massive delete transaction not use roll back segment [message #54895]

Fri, 13 December 2002 12:53

Brunda Sathi
Messages: 1
Registered: December 2002

Junior Member

Is there a way I can set a massive delete transaction not to use roll back transaction?. Since, this kind of transaction will significantly affect other transactions, there by decreasing the performanace, I would like to bypass roll back segment.

Thanks

Report message to a moderator

Re: Can I set a massive delete transaction not use roll back segment [message #54897 is a reply to message #54895]

Fri, 13 December 2002 13:51

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

Senior Member
Account Moderator

u can make a transaction to use a particular rolbback segment.

use

set transaction user rollback segment < segment name >;

Make sure u issue this, as the first statment,
before doing anything.

Report message to a moderator

Previous Topic:	Query Performance issues...
Next Topic:	URGENT:Couldn't figure out why this statement fails.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:36:45 CDT 2024