| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: memory refresher
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
kevin_at_dulcian.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: kevin_at_dulcian.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Apr 11 2001 - 11:50:35 CDT
 |
 |