How much amount of Redo Generated?

From: Jumma <juma_gandhi_at_yahoo.com>
Date: 26 Aug 2004 22:22:57 -0700
Message-ID: <c9ade84.0408262122.53fa0052@posting.google.com>

Hi,

I wanted to find out the amount of transaction which is currently going on.
In this regard I heard that the CPODR_BNO column of SYS.X$KCCCP table finds out the redo amount generated for the current redo log file.

Via searching this google site, I found the solution of this.

An expert said that:
The column labelled CPODR_BNO shows the Current position of the Database Redo Block Number. Multiply by (usually) 512 bytes to get the position in more meaningful terms. For example, if it displays 500, it means 256KB of redo has been written into the current log. The number resets at each log switch.

I like to ask why we multiply the value of CPODR_BNO with 512 in order to get the redo amount.
Is that process gives the correct amount of redo generated for the current transactions?

Is that necessary to perform logswitch manually to findout the redo amount as discussed above?

Thanks in Advance.

Juma Received on Fri Aug 27 2004 - 00:22:57 CDT