|
-
Hi
I am having very poor performance of redo log in my database.
I normally run long running batch processes on our database.
I am seeing the following:
redo log space requests ===1198
redo log space wait time ===68814
I have my log_buffer set to 5242880
we have only 2 mirrored redo log files of size 200MB.
Should I add more redo log files ? What size?
Any other suggestions appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|