Skip to Main Content

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!

Why archived log file'size in oracle database is average 44 mega bytes and redo log files is 512 meg

Quanwen ZhaoJul 10 2017 — edited Jul 25 2017

Hello,

I can see archived log file's size is 44 mega bytes and redo log file is 513 mega bytes lately.

[oracle@orcl28 arch]$ ls -lrth

total 1.4G

-rw-r----- 1 oracle oinstall 43M Jul  9 23:01 1_22298_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul  9 23:49 1_22299_910276848.dbf

-rw-r----- 1 oracle oinstall 43M Jul 10 01:30 1_22300_910276848.dbf

-rw-r----- 1 oracle oinstall 54M Jul 10 03:00 1_22301_910276848.dbf

-rw-r----- 1 oracle oinstall 46M Jul 10 03:00 1_22302_910276848.dbf

-rw-r----- 1 oracle oinstall 54M Jul 10 03:36 1_22303_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 06:56 1_22304_910276848.dbf

-rw-r----- 1 oracle oinstall 43M Jul 10 08:00 1_22305_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 08:29 1_22306_910276848.dbf

-rw-r----- 1 oracle oinstall 46M Jul 10 08:36 1_22307_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 08:52 1_22308_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 09:07 1_22309_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 09:19 1_22310_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 09:31 1_22311_910276848.dbf

-rw-r----- 1 oracle oinstall 32M Jul 10 09:40 1_22312_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 09:51 1_22313_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 10:01 1_22314_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 10:12 1_22315_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 10:23 1_22316_910276848.dbf

-rw-r----- 1 oracle oinstall 46M Jul 10 10:31 1_22317_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 10:42 1_22318_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 10:51 1_22319_910276848.dbf

-rw-r----- 1 oracle oinstall 45M Jul 10 11:01 1_22320_910276848.dbf

-rw-r----- 1 oracle oinstall 45M Jul 10 11:11 1_22321_910276848.dbf

-rw-r----- 1 oracle oinstall 47M Jul 10 11:22 1_22322_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 11:35 1_22323_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 11:50 1_22324_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 12:08 1_22325_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 12:28 1_22326_910276848.dbf

-rw-r----- 1 oracle oinstall 44M Jul 10 12:49 1_22327_910276848.dbf

-rw-r----- 1 oracle oinstall 43M Jul 10 13:10 1_22328_910276848.dbf

-rw-r----- 1 oracle oinstall 43M Jul 10 13:32 1_22329_910276848.dbf

[oracle@orcl28 orcl28]$ ls -lrth redo0*

-rw-r----- 1 oracle oinstall 513M Jul 10 11:50 redo04.log

-rw-r----- 1 oracle oinstall 513M Jul 10 12:08 redo05.log

-rw-r----- 1 oracle oinstall 513M Jul 10 12:28 redo06.log

-rw-r----- 1 oracle oinstall 513M Jul 10 12:49 redo07.log

-rw-r----- 1 oracle oinstall 513M Jul 10 13:10 redo03.log

-rw-r----- 1 oracle oinstall 513M Jul 10 13:32 redo02.log

-rw-r----- 1 oracle oinstall 513M Jul 10 13:48 redo01.log

and I query dynamic performance view 'v$active_session_history' period at 13:40-13:50 wait event.

select event,wait_class,count(*) from v$active_session_history

where sample_time between to_date('20170710 13:40','yyyymmdd hh24:mi') and to_date('20170710 13:50','yyyymmdd hh24:mi')

and event is not null

and machine != 'orcl28'

group by event,wait_class

order by 1 desc,3 desc;

event                                             wait_class          count(*)

-------------------------------------         ----------------       ------------

log file sync                                   Commit              17

db file sequential read                   User I/O             5

SQL*Net more data to client          Network            3

SQL*Net more data from client      Network            3

flashback log file sync                   User I/O             1

log file sync is major problem? and how to solve it ?

This post has been answered by Jonathan Lewis on Jul 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 10 2017
Added on Jul 10 2017
13 comments
874 views