Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: memory refresher

RE: memory refresher

From: Haskins, Ed <Ed.Haskins_at_VerizonWireless.com>
Date: Wed, 11 Apr 2001 09:50:35 -0700
Message-ID: <F001.002E72E5.20010411094552@fatcity.com>

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Haskins, Ed
  INET: Ed.Haskins_at_VerizonWireless.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). Received on Wed Apr 11 2001 - 11:50:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US