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