This content has been marked as final. Show 3 replies
Possible solutions depend on four digit Oracle version and edition and platform, neither of which you mention.
Streams is implemented by shipping and reading archivelogs, so if you disable archivelog streams will stop to function.
Something is architecturally really really wrong if you want top update 40 percent of the database in one shot.
You are trying to fight symptoms, where a cure is needed.
Problem is not archivelog. Problem is the architecture of this 'application'.
Senior Oracle DBA