Re: IMPORT 20G database ..(SLOW!!!!)

How about a large buffer:
buffer=500000
commit=y
indexes=n
log=A.log

What slows you down is the redo logs. Make them at least 20mb each, put them on a fast disk.

Make the log_buffer a mulitple of 1024000 bytes. About 1024000 bytes is adequate for normal use; for the import consider 5 or 10Mb.

Cheers, Roelof

R. Schierbeek, DBA

email : info_at_bytelife.com
www   : www.bytelife.com
SQL   : www.bytelife.com/sql4dba.htm

JK Yao wrote:
> >
> > dear all,
> >
> > I imported the database and spend more than 20 hours and finish not
> > even half way (7G). How to solve it?
> > 1. Is it normal that impoting got hang when import big table (millions
> > rows)?
> > 2. Should I import those big tables one by one first and then do full
> > import. Will this help?
> >
> > Our database is about 20G.
> > I used following parameters:
> >
> > full=y
> > commit=y
> > indexes=n
> > log=A.log
> >
> > Need help!
> > Thanks.
> >
> > regards,
> > JK
Received on Sat Aug 18 2001 - 04:12:27 CDT