RE:

Well.,.. It all depends on your backup strategy.

How about increasing redo logfile size?

Sandeep.         

	-----Original Message-----
	From:	Sandy Ocheltree [SMTP:ora_dba_at_hotmail.com]
	Sent:	Tuesday, August 01, 2000 12:03 AM
	To:	Multiple recipients of list ORACLE-L
	Subject:	

	We've recently had a lot of problems with our archive log directory
filling
	and the database freezing. Now that I've mastered how to fix this
quickly,
	I'm wondering why I have to fix it so often. Is there some sort of
	optimal/minimum size for an archive log directory? We are running a
1
	terabyte db with varying amounts of activity, and the archive log
directory
	can hold up to 11G. The archived logs are being written to tape
every 4 hrs,
	but this often isn't fast enough--sometimes the directory fills in
an hour.
	Should I just increase the frequency that the logs are written to
tape? Add
	space? Any advice would be appreciated.

	Thanks,
	Sandy

	
________________________________________________________________________
	Get Your Private, Free E-mail from MSN Hotmail at

	-- 
	Author: Sandy Ocheltree
	  INET: ora_dba_at_hotmail.com

	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
	also send the HELP command for other information (like subscribing).