| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: What makes Export slow ?
Using a large buffer size allows more data to be written via export (a C
Program) from the database to a file. The buffer specifies the size of each
write to the database.
Direct=Y was added in Oracle7 and allows export to bypass the SQL communication layer and write data from the database to the export file. Generally this is used to speed up exports, however, there have been issues with constraints, etc.
Large rollback segment option can only be used if you can really assure that no one is using the database and you can disable all other rollback segments. Otherwise, this option is useless.
Thank You
Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: Stephen.Karniotis_at_Compuware.com Web: www.compuware.com -----Original Message----- Sent: Monday, May 20, 2002 2:04 PM To: Multiple recipients of list ORACLE-L Subject: 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 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/~jwiltonReceived on Tue May 21 2002 - 08:48:29 CDT
> -----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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: Stephen_Karniotis_at_compuware.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).
 |
 |