Oracle-L: RE: What makes Export slow ?

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Mon, 20 May 2002 09:43:35 -0800
Message-ID: <F001.00464C7F.20020520094335@fatcity.com>

Would you post the parameter file ??

Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export ,
and also you can have a look at the DISK I/O stats ( verify the OFA is same on both the boxes ).

Thanks,
Madhu

-----Original Message-----
Sent: Monday, May 20, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L

Hi guys,

I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space)

I create the database with the same script that I used to for my database in the older machine,

When I export my database from the older machine it was very fast and when I import to newer machine it was fast too,

and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : (

The no of records are the same for both machines
v$session_wait.seconds_in_wait is more than 10000

Thank you

--

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

Author: Sinardy Xing
INET: SinardyXing_at_bcs-ach.com.sg

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: Reddy, Madhusudana
INET: Madhusudana.Reddy_at_bestbuy.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------