Re: redo curiosity
Date: Thu, 18 Feb 2010 13:26:34 -0500
One of the reasons could be that 8i didn't have to populate (and cleanup) all these AWR, ASH tables on regular basis. And this activity could contribute substantially considering that your user's activity is insignificant.
On Thu, Feb 18, 2010 at 1:17 PM, Maureen English <maureen.english_at_alaska.edu
> We have an Oracle 8i database and an Oracle 10g database that
> currently both serve the same purpose. We're moving off the
> 8i to the 10g, just not as quickly as we'd hoped.
> The two databases have the same accounts and the same jobs
> running against them...both are reporting instance databases,
> so users do very little in terms of creating and updating
> anything. The 2 databases have the same materialized views
> with the same nightly refreshes done at the same time each
> night...if the materialized view in one database is done with
> a fast refresh, that's how it's done in the other database.
> Both databases have the same size redo logs, but the 10g
> database ends up with 2-3 times as many archive logs as the
> 8i database.
> I'm looking at the database parameters to see what's so
> different...any other suggestions as to why the 10g database
> would be generating so much more redo?
> - Maureen