On Mon, 20 May 2002, Reddy, Madhusudana wrote: > Huge Buffer, commit=y, direct=y, assigning the big rollback segment > should help you to have faster export ,
What do you mean "assigning the big rollback segment?" How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -----Original Message----- > Sent: Monday, May 20, 2002 3:43 AM > To: Multiple recipients of list ORACLE-L > > 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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).