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:[EMAIL PROTECTED]]
> Sent: Monday, March 26, 2001 3:26 PM
> To: [EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]]
> Sent: Tuesday, 27 March 2001 5:48
> To: [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
