Re: determine log space used before a switch ?

• X$KCCCP will have the redo block number (CPODR_BNO) in the log file. THe log block is X$KCCLE.LEBSZ .
• So by joining X$KCCLE and X$KCCCP we can find the current block in the redo log file.
• Log file size/X$KCCLE.LEBZ will give you the number of log blocks for that log file.
• Let us say it is K. X$KCCCP.CPODR_BNO/K*100 will give how much % of log file is full.
• The above algorithm in 8.1.7 should show how much of the current redo file is filled
• To be considered accurate current file must be used;

connect internal    

• must be connected as SYS

set echo on
set linesize 150

REM blocks written to current log

SELECT LA.CPODR_BNO
FROM X$KCCCP LA ; REM Blocks size

SELECT LEBSZ
FROM X$KCCLE; REM current redo log usage percentage

SELECT LA.CPODR_BNO "curr blocks" ,(SELECT LA.CPODR_BNO/LE.LESIZ*100 FROM X$KCCLE LE WHERE ROWNUM = 1) "curr redo% used" FROM X$KCCCP LA
WHERE ROWNUM = 1;
-- WHERE CPODR_BNO > 0; On 8 Apr 2003 08:31:00 -0700, beingmeus_at_yahoo.com (Sravan) wrote:

>Hello,
>1) I was wondering it there is a way to find the the actual space used
>in a redolog, before it switches. My redologs are 200 MB.
>
>2) My alert log doesn't report any checkpoint information, is there a
>reason? Did I forget to turn on the magic switch. It does report the
>logswitch activity, though !!!
>
>Thanks
>Kevin
Received on Tue Apr 08 2003 - 18:50:38 CDT