Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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