RE: Oracle7.3 ARCH parameters settings -- what is the reasonable ceil

Never mind, I figured it out.

I plugged in the highest values I dared in init.ora, and Oracle = informed me
that the max values are 128 and 5. We had 128 and 4 buffers.

I changed it to 5, but that won't speed up ARCH by very much.

Oracle8i with up to 5 archivers sounds much better, I wonder if it = really is
faster.

Regards,
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

	-----Original Message-----
	From:	Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
	Sent:	Saturday, August 19, 2000 12:14 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	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>


	Ph: (902) 426-4774
	--=20
	Author: Boivin, Patrice J
	  INET: BoivinP_at_mar.dfo-mpo.gc.ca

	Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
	San Diego, California        -- Public Internet access / Mailing
Lists
	--------------------------------------------------------------------
	To REMOVE yourself from this mailing list, send an E-Mail message
	to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
	the message BODY, include a line containing: UNSUB ORACLE-L
	(or the name of mailing list you want to be removed from).  You may