Re: redo curiosity

  • From: Maureen English <maureen.english@xxxxxxxxxx>
  • To: "Oracle-l@xxxxxxxxxxxxx" <Oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 18 Feb 2010 09:40:17 -0900

Nope, no forced logging.

I vaguely remember making some init parameter change a while back for
our 10g databases because we kept getting checkpoint not complete (or
something like that) error in the alert logs.

If it's because more info is being sent to the redo logs, then it's
a *whole lot* more!  But we've found that the overhead for 10g is a
lot more than it was for 8i, so I guess it shouldn't surprise me.

- Maureen


TESTAJ3@xxxxxxxxxxxxxx wrote:

does one database happen to have forced logging?

The other thing is (i'm making an educated guess here) is that more info is being sent to redo logs in newer versions, especially for things like log miner.

joe

_______________________________________
Joe Testa, Oracle Certified Professional
Senior Engineering & Administration Lead
(Work) 614-677-1668
(Cell) 614-312-6715

Interested in helping out your marriage?
Ask me about "Weekend to Remember"


--
//www.freelists.org/webpage/oracle-l


Other related posts: