In your case the log switch occurs every one hour. That means either your redo log file is big or less number of transaction takes place in an hour.
Oracle writes transaction info sequentially in redo log file. When the crrent one fills, it starts writing into next one.




Reply With Quote