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- Sent: Tuesday, 27 March 2001 5:51 To: Multiple recipients of list ORACLE-L 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: Glenn Travis 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). -- 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).
Re: Redo Log size used
See your alertSID.log by using tail -f alertSID.log Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Mon, 26 Mar 2001 11:51:11 -0800 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: Glenn Travis 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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).
RE: Redo Log size used
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).
