RE: Redo Log size used

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 26 Mar 2001 15:02:46 -0800
Message-ID: <F001.002D83C0.20010326145029@fatcity.com>

Hi Glenn,

Yes, your query is fine, and does just what you think. Please see http://www.ixora.com.au/q+a/0102/06135327.htm for the meaning of cpodr_bno.
Please see http://www.ixora.com.au/tips/tuning/log_buffer_size.htm for the relationship between log blocks and the log buffer.

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
Sent: Tuesday, 27 March 2001 7:27
To: Steve Adams
Cc: Oracledba

As always your script was exactly what I was looking for. I am assuming the
column sys.x_$kccle.lesiz is number of blocks which make up the logfile, and
sys.x_$kcccp.cpodr_bno is number of blocks in the log file currently in use,
although I can't decipher the column name meaning. Using your http://www.ixora.com.au/scripts/redo_log.htm#log_block_size.sql script, I
was able to see the number of bytes in a redo log block. Again, I am assuming it is bytes (why is the redo log block size different from the log
buffer size (set in the init.ora file)?). What exactly is the sys.x_$kccle.lebsz column?

I wrote this query to give me the number of MB currently in use by in the
redo log file.

select

  le.leseq  log_sequence#,
  le.lesiz * le.lebsz /1024 /1024 logmbtotal,
  cp.cpodr_bno * le.lebsz /1024 /1024 logmbinuse

from
  sys.x_$kcccp cp,
  sys.x_$kccle le
where

  le.inst_id = userenv('Instance') and
  cp.inst_id = userenv('Instance') and
  le.leseq = cp.cpodr_seq

Am I making the correct assumptions here?

> -----Original Message-----
> From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
> Sent: Monday, March 26, 2001 3:26 PM
> To: c-glenn.travis_at_wcom.com
> Cc: Oracledba
> Subject: RE: Redo Log size used
>
>
> Hi Glenn,
>
> Try 'log_file_usage.sql' at
> http://www.ixora.com.au/scripts/redo_log.htm#log_file_usage.
>
> @ Regards,
> @ Steve Adams
> @ http://www.ixora.com.au/
> @ http://www.christianity.net.au/
>
>
> -----Original Message-----
> From: Glenn Travis [mailto:c-glenn.travis_at_wcom.com]
> Sent: Tuesday, 27 March 2001 5:48
> To: c-glenn.travis_at_wcom.com
> Subject: Redo Log size used
>
>
> What can I query to see how much of the redo log file is currently in
use?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).

Received on Mon Mar 26 2001 - 17:02:46 CST