Re: Redo log buffer size

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Sat, 04 Nov 2006 04:57:37 GMT
Message-ID: <pan.2006.11.04.04.57.37.122970@gmail.com>

On Fri, 03 Nov 2006 16:51:12 -0800, oracle dba wrote:

> Hi all,
>
> According to books redo will to written to file after 1MB is full. So
> is there any way that our redo log buffer is equal to or more than
> 10MB.

What is your transaction rate? (filling the log buffer, in MB/sec)
What is the rate of writing to disk? (emptying log buffer, in MB/sec)

If 1) is greater than 2), what happens?

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Fri Nov 03 2006 - 22:57:37 CST