Home » RDBMS Server » Performance Tuning » Archive log
Archive log [message #229782] Tue, 10 April 2007 01:04 Go to next message
ataufique
Messages: 79
Registered: November 2006
Member
In my database records are continously inserted/loaded by
using C / ProC programs...In a day around 6 millions records
are inserted.
Should i keep the archive log on such that it doesn't effect
my performance.
Re: Archive log [message #229786 is a reply to message #229782] Tue, 10 April 2007 01:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Any association between archived log and peformances is irrelevant (unless you put your archived logs on overloaded disk or on network).
Archived logs are for availability. Either you need it and use it, or you don't and switch to no archived log mode.
You can remove them as soon as you no more need them for recovery but this will change anything on performances.

Regards
Michel

Re: Archive log [message #230419 is a reply to message #229786] Wed, 11 April 2007 22:16 Go to previous messageGo to next message
ataufique
Messages: 79
Registered: November 2006
Member
When archive log is on, does redo log generated when
1. data is loaded using sql loader direct path
2. when using bulk collect / forall for insert/update
Re: Archive log [message #230420 is a reply to message #230419] Wed, 11 April 2007 22:28 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
If you make any DML/DDL changes archive log is going to be generated. There is very very less impact on db if you make your db in no archive log mode, but for availability/recovery purpose you should require archive logs.

Oracle recommends db should be in archive log mode.


Regards,
Harsh
Re: Archive log [message #230430 is a reply to message #230419] Wed, 11 April 2007 23:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no difference when db is in archivelog or noarchivelog mode.
The redo logs generated are the same.

Regards
Michel
Re: Archive log [message #230474 is a reply to message #230430] Thu, 12 April 2007 01:45 Go to previous messageGo to next message
ataufique
Messages: 79
Registered: November 2006
Member
what i want to know is in below cases is redo log generated ?
1. data is loaded using sql loader direct path
2. when using bulk collect / forall for insert/update
Re: Archive log [message #230478 is a reply to message #230474] Thu, 12 April 2007 01:54 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Redo logs are always generated, more or less.
lesser in 1. than in 2.

Regards
Michel
Previous Topic: basics step
Next Topic: efficiently populating tables
Goto Forum:
  


Current Time: Sun Dec 04 00:20:22 CST 2016

Total time taken to generate the page: 0.08182 seconds