Re: redo logfile ?

Try this :
col x format 99,999,999 hea 'CurrBytesinCurrentRedoLog' select cpodr_bno x from x$kcccp;

I am quite sure that I saw this query in a posting by K.G. Hemant
At 06:57 AM 07-05-03 -0800, you wrote:
>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).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

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).