Re: archive log

Ari Kaplan wrote:
>
> Archivelog does not use up much resources. Your slower performance could
> be due two three things:
> 1) You are putting your archive directory on the same drive as your redo
> logs. This will be bad for performance, and should be put on a separate
> drive, hopefully on a low-activity device.
>
> 2) Your redo log files are sized too small, and this is causing frequent
> redo log switches. Increasing the size of all redo logs will improve this
>
> 3) Your archive volume's disk has filled up. If this is the case, your
> database will more than slow down - it will effectively stop (except for
> SELECT statements). Be sure to remove old archive logs daily,and monitor
> your free space on the device with archive log files.
>
> -Ari Kaplan
> Independent Oracle DBA Consultant
>
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> <-> For 132+ Oracle tips, visit my Web Page: <->
> <-> <->
> <-> http://homepage.interaccess.com/~akaplan <->
> <-> <->
> <-> email: akaplan_at_interaccess.com <->
> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
>
> Haris Kusumo (ikusumo_at_elixir.com.au) wrote:
> : Hi,
> :
> : I am running oracle ver 7.2.2.x database on IBM RS/6K 970.
> : I just enable archivelog on for backup and recovery purposes, so
> : when the system crash I can recover it up to the last archivelog.
> :
> : but for some reason, after archivelog is enable the system seems to be
> : very slow...
> : does the archivelog generally use a lot of system resources?
> :
> : is there a way to set it so it doesn't uses alot of system resource?
> :
> : I though the information written to the archivelog is
> : update/delete/insert not select. am I right ?
> :
> : I appreciated if you could e-mail me the reply to
> : haris_kusumo_at_modusmedia.com or
> : hkusumo_at_elixir.com.au
> :
> : since I can't get access to new at work.
> :
> : Thanks in advance
> : - Haris -

Hi,

in addition you should keep archive logs and database files on separate disk drives.

-- 
Regards

Matthias Gresz    :-)