Oracle7.3 ARCH parameters settings -- what is the reasonable ceil ing?

I am importing a database that is in archivelog mode, and in my opinion = this
is taking WAY too long (over 24 hours).

This is a digital alpha, Digital UX 4.0D, Oracle 7.3.

Log_archive_buffer_size =3D 128
Log_archive_buffers =3D 4.

I strongly suspect that ARCH is the bottleneck, the two CPUs are not = 100%
busy and neither is the RAID system.

As usual Oracle doesn't mention in the manuals what the maximum values = are
for these parameters on D-UX, but Alomari's book mentions that a = balance has
to be reached between the speed of ARCH and the rest of the background processes. (p.204).

Once the import has finished I would like to set these parameters appropriately. What parameters have worked for you?

I am thinking of multiplying these values by 4, 8 or even more, if = there is
no detrimental effect.

We don't have an equivalent test server, it's always mentioned as a "possibility" or as "a good idea", but never gets done so I don't think = it's
a priority here. I wish I had one, I could try different values!

TIA
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20 Received on Sat Aug 19 2000 - 09:07:43 CDT