| Archive log [message #229782] |
Tue, 10 April 2007 01:04  |
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  |
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 |
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 |
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 |
 |
Michel Cadot
Messages: 68651
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
