Re: Meaning of redo wastage

Doug

Redo wastage can be safely ignored. Basically, it's the number of bytes "wasted" because redo blocks needed to be written before they are completely full. Early writing may be needed to commit transactions, to be able to write a database buffer, or to switch logs. You can't do much about it, so ignore it.

HTH. Pete

Doug Cowles wrote:

> In the Bstat Estat report, there is a line called redo wastage. Mine
> has a value of
> 49.66% per transaction. What gives? What does it mean,and how do I fix
> it?
> I have 3 rollback segments sized at initial 16M next 16M minextents 20 -
> for a pretty
> good size, not too much growing and shrinking going on. This if for a
> datamart app
> that is undergoing some test loads at the moment...
>
> - Dc.

--

Regards

Pete

Received on Fri Jun 18 1999 - 11:58:42 CDT