Import very slow-URGENT!!!

[Anurag Minocha]

Hi,
We are using oracle 8.0.5 in NT. Our's is a developement database hence
we have to drop all the objects for a particular user and import them
again. This we do atleast twice a day.
The command we use to expoirt is as follows
exp80 <username>/<password>@<service name> file= exp.dmp full=y

and to import we use
imp80 <username>/<password>@<service name> file=exp.dmp fromuser=r2
touser=r2

The problem is that the import has become very slow and sometimes it
justs hangs after importing all the tables and before enabling the
constraints.

Any help on how to speed up the import process will be appreciated.

Thanks
anurag

also reply at
anu...@synery-infotech.com

[Alex Hudghton]

Anurag Minocha wrote in message <37B29EDD...@synergy-infotech.com>...

I assume you are doing this to start with a 'base' copy of the data (?) Why
not keep a database copy on the system or on tape and restore from that
(i.e. copy the datafiles and recreate the controlfile) each time you want a
refresh ?

Alex

[Christoph Gehrke]

Hi Anurag,
I dont`t know why you do that, but have a look on databases Logs
(ORCLALRT.log ?) are there any `checkpoint not complete`.
If there are, you surely can tune your database.
change SGA Parameters, RedoLogfiles, or create an new instance with better
blocksize

have a look at www.hoffmann-kiel.de/stdinst.html

Christoph

Anurag Minocha schrieb in Nachricht

<37B29EDD...@synergy-infotech.com>...
>Hi,
>We are using oracle 8.0.5 in NT. Our's is a developement database hence
>we have to drop all the objects for a particular user and import them
>again. This we do atleast twice a day.
>The command we use to expoirt is as follows
>exp80 <username>/<password>@<service name> file= exp.dmp full=y
>
>and to import we use
>imp80 <username>/<password>@<service name> file=exp.dmp fromuser=r2
>touser=r2
>
>The problem is that the import has become very slow and sometimes it
>justs hangs after importing all the tables and before enabling the
>constraints.
>
>Any help on how to speed up the import process will be appreciated.
>

[kal...@my-deja.com]

You can increase the size of your buffer parameter, which may help some.
I've also found that using a large rollback segment can speed things
up.

In article <37B29EDD...@synergy-infotech.com>,

Anurag Minocha <anu...@synergy-infotech.com> wrote:
> Hi,
> We are using oracle 8.0.5 in NT. Our's is a developement database
hence
> we have to drop all the objects for a particular user and import them
> again. This we do atleast twice a day.
> The command we use to expoirt is as follows
> exp80 <username>/<password>@<service name> file= exp.dmp full=y
>
> and to import we use
> imp80 <username>/<password>@<service name> file=exp.dmp fromuser=r2
> touser=r2
>
> The problem is that the import has become very slow and sometimes it
> justs hangs after importing all the tables and before enabling the
> constraints.
>
> Any help on how to speed up the import process will be appreciated.
>
> Thanks
> anurag
>
> also reply at
> anu...@synery-infotech.com
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

[kal...@my-deja.com]

Also, I was reading yesterday about the COMMIT=Y parameter. Oracle
recommends setting this to Y for large data imports. It will commit
after every array insert vs. after every table, which may actually
make it faster since you're not having to use as much rollback
segment space, but I haven't actually tried it yet.