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 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: jwilton_at_speakeasy.net

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