OraFAQ Forum: Server Administration » Rollback Seg for Import

Home » RDBMS Server » Server Administration » Rollback Seg for Import

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

Rollback Seg for Import [message #58446]

Wed, 27 August 2003 07:15

Nagesh Babu D
Messages: 1
Registered: August 2003

Junior Member

Hi,

Is there any way to assign specific big rollback segment for an import process to speed up. I know, "sql> set transaction use rollback segment segment_name; at session level"

How can i achive this for an import ?

Thanks,
Nagesh

Report message to a moderator

Re: Rollback Seg for Import [message #58448 is a reply to message #58446]

Wed, 27 August 2003 09:27

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

Senior Member
Account Moderator

i dont think so.
Only way to make it happen is to make One big RBS online and all other rbs OFFLINE! which i beleive, u dont want to do.
to speed up import 
1. u can set your BUFFER to a higher value
2. import only table data and NOT their indexes.
   recreate the indexes later.
   this will also save your UNDOSEGMENT space

Report message to a moderator

Re: Rollback Seg for Import [message #58449 is a reply to message #58446]

Wed, 27 August 2003 09:31

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

Senior Member
Account Moderator

what i meant is ,
drop ur indexes before you do the import.
import only the data.
recreate the indexes later

Report message to a moderator

Previous Topic:	Oracle PatchSet Install
Next Topic:	50% CPU Usage

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:40:41 CDT 2024