The idea of huge rollback segment is just to eliminate the contention the rollback segment. Well its not always applicable ( possible make sure all the other applications are not used), but we can create a big rollback segment and bring it on line and make other rollback segments offline, and run the export . So definitely the big rollback segment will be used.
COMMIT=Y is not a parameter for export , instead good for import , its my mistake. Somewhere I have read that NFS Mounted file system will make the export slower . Thanks for your correction, Madhu -----Original Message----- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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).
