Kevin,
When you say migration...I assume you're doing a data migration from some
legacy to Oracle...and likely you're using DataMig to take data that's in
the staging area ((source(Oracle)) and importing it into the target Oracle
instance, yes?
Yes, create a RBS called RBIG and size it appropriately. Are 70,000 records
in one table or does the whole migration consist of 70,000 records in a
multitude of tables?
Ed Haskins
Oracle DBA
Verizon Wireless
-----Original Message-----
Sent: Wednesday, April 11, 2001 1:06 PM
To: Multiple recipients of list ORACLE-L
Hi all,
If I am doing a migration of say 70 thousand records, isn't it a
good idea
to turn off all of my little rollback segments and turn on a couple of big
rgs? And, how big do you guys think they should be if that is the case? I
am trying to increase the performance of this migration, but it is not easy.
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
