RE: What makes Export slow ?

:RE: What makes Export slow ? 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

RE: What makes Export slow ?

If an expert is done with consistent = 'N' it still must preserve some information. In the beginning export runs some selects against the data dictionary and needs that data to be consistent throughout the export. If that data changes then it needs to be reconstructed from the undo generate

RE: What makes Export slow ?

On Mon, 20 May 2002, Reddy, Madhusudana wrote: > 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

RE: What makes Export slow ?

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

RE: What makes Export slow ?

--- Jeremiah Wilton <[EMAIL PROTECTED]> wrote: > 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 does COMMIT=Y do in an export? it causes an error message! ___

RE: What makes Export slow ?

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

RE: What makes Export slow ?

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

What makes Export slow ?

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 im