Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how do we find redo log size

636903Jul 16 2008 — edited Jul 17 2008
How do we find the current size of a redo lof file?

Also the current size of control file?

Thanx in advance....

Comments

584650
select bytes from v$log; -- redo log size

select (block_size*file_size_blks)/1024 from v$controlfile; -- controlfile size in KB although double check size on disk (might be some overhead not accounted for).
637039
2.
select sum(2*t.RECORD_SIZE*t.RECORDS_TOTAL) from v$controlfile_record_section t
Try this link, for more information
http://www.ixora.com.au/q+a/0102/02112927.htm
637039
v$controlfile view doesn't have any information about controlfile size.
Fco Munoz Alvarez

Hi,

This query will show you the redolog files sizes and all the groups.

select l.group#,f.member,l.archived,l.bytes/1078576 bytes,l.status,f.type
  from v$log l, v$logfile f
 where l.group# = f.group#
/

Best Regards,

Francisco Munoz Alvarez
www.oraclenz.com

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 14 2008
Added on Jul 16 2008
#general-database-discussions
4 comments
60,831 views