Xref: alice comp.databases.oracle.server:39801 Path: alice!news-feed.fnsi.net!netnews.com!newspeer1.nac.net!logbridge.uoregon.edu!su-news-hub1.bbnplanet.com!su-news-feed2.bbnplanet.com!news.gtei.net!gateway.sequent.com!scel.sequent.com!news From: "Phil Hoggins" Newsgroups: comp.databases.oracle.server Subject: Re: Import Utiltiy Date: 4 Feb 1999 12:56:09 GMT Organization: Sequent Computer Systems, Inc. Lines: 34 Message-ID: <01be503d$990632e0$ab75549e@w-philh02.uk.sequent.com> References: <36b92366.0@news1.ibm.net> X-Newsreader: Microsoft Internet News 4.70.1155 To improve the performance of import there are a number of things you can do. 1. If you are on a multi proc machine split the import into multi streams by user. 2. If you are importing indexes increase the sort_area_size to as large as you can as this will reduce the amount of time it takes to build the index. 3. Compile up the impst (single task executable for import), gives about 20% performance gain. I think the command is make -f rdbms.in?? impst 4. disable redo logging activity (not supported) _disable_logging=true Rgds, Phil Alianto wrote in article <36b92366.0@news1.ibm.net>... > Most of our client use Oracle 7.x.x database running under HP 9000. > We usually refresh data from one machine to another machine, and so far we > didn't any problem with export/import utility. > > I have some questions about import utility : > 1. How to increase import performance ? > 2. Where can I find some information that will increase import performance ? > > Thanks, > > Alianto > > >