Re: Redo Log File Sizes
- From: Jeremiah Wilton <jeremiah@xxxxxxxxxxx>
- Date: Wed, 23 Jan 2008 18:21:47 -0800
Dereck L. Dietz wrote:
When we have two or more processing performing updates, deletes and/or inserts at the same time our system slows to a crawl.
I was under the impression that Oracle suggests that Redo Log Files be sized so they switch only every 20 minutes or so. Is the frequency of the log file switching in the excerpt below normal?
The 20 minute rule is not based in any type of science, and can be filed up there with "BCHR must be 99.9 or greater."
Based on your post, there does not seem to be any evidence or reason to believe that the performance problems are caused by logfile size or switch frequency. You need to look at the wait events on the database at the time if the slowdown. If you are on 10g or above, a time-series history of wait data is available in dba_hist_active_sess_history. Any conjecture without looking at the waits is just that.
Regards,
Jeremiah Wilton
ORA-600 Consulting
http://www.ora-600.net
.
- Follow-Ups:
- Re: Redo Log File Sizes
- From: joel garry
- Re: Redo Log File Sizes
- References:
- Redo Log File Sizes
- From: Dereck L. Dietz
- Redo Log File Sizes
- Prev by Date: Re: A potential bug (infinite loop) in Oracle: querying v$access
- Next by Date: was(can someone please explain what this blog tagging this is all about?), now, happy NY!
- Previous by thread: Redo Log File Sizes
- Next by thread: Re: Redo Log File Sizes
- Index(es):
Relevant Pages
|
|
