Oracle-L: RE: redo logfiles

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Tue, 06 May 2003 09:42:33 -0800
Message-ID: <F001.005914F5.20030506094233@fatcity.com>

Hi,

Finding how much percentage of current redo log is filled is bit tricky since the information is not exposed in any V$ views. We have to directly query the X$tables to get that information. The X$views we use here are X$KCCLE (Kernel Cache ControlfileComponent Log file Entry) and KCCCP (Kernel Cache Checkpoint Progress).

SELECT

le.leseq  	CURRENT_LOG_SEQUENCE#,
100*cp.cpodr_bno/LE.lesiz	PERCENTAGE_FULL
from
	x$kcccp cp,x$kccle le
WHERE
	LE.leseq =CP.cpodr_seq

;
CURRENT_LOG_SEQUENCE# PERCENTAGE_FULL

--------------------- ---------------
                    6      .428710938

Here X$KCCCP.CPODR_BNO tells the current log block in the redo log file and X$KCCLE.LESIZ gives the number of (log) blocks in that log file.

(Thanks to http://www.jlcomp.demon.co.uk/faq/redologuse.html)

Best Regards,
K Gopalakrishnan

-----Original Message-----
Charlie_Mengler_at_HomeDepot.com
Sent: Tuesday, May 06, 2003 9:57 AM
To: Multiple recipients of list ORACLE-L

If possible, I'd like to determine how full ( how close to doing a switch) the current
redo logfile is at the time I do a query. However I can't seem to identify which "V$"
view contains the necessary information.

I'd appreciate it if somebody can provide me the name of the V$ view which I
can use to see how close to switching the current redo logfile actually is.

TIA & HAND!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author:
INET: Charlie_Mengler_at_HomeDepot.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: K Gopalakrishnan
INET: kaygopal_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------