Archive log [message #229782] |
Tue, 10 April 2007 01:04 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #230419 is a reply to message #229786] |
Wed, 11 April 2007 22:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #230474 is a reply to message #230430] |
Thu, 12 April 2007 01:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 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
|
|
|