Is It Possible To Specify The Size Of The Flashback Buffer In The Sga

1.	Is It Possible To Specify The Size Of The Flashback Buffer In The Sga?
Answer» Yes, but indirectly. The SIZE of the Flashback Buffer is set to 2 * LOG_BUFFER. For performance reasons, it’s recommended to set LOG_BUFFER to at least 8MB for databases running in Flashback Mode. UPDATE: For LARGE 11.1.0.7+ databases with more than a 4GB SGA, you may consider SETTING LOG_BUFFER to values in the range of 32-64 MB. Yes, but indirectly. The size of the Flashback Buffer is set to 2 * LOG_BUFFER. For performance reasons, it’s recommended to set LOG_BUFFER to at least 8MB for databases running in Flashback Mode. UPDATE: For large 11.1.0.7+ databases with more than a 4GB SGA, you may consider setting LOG_BUFFER to values in the range of 32-64 MB.

Is It Possible To Specify The Size Of The Flashback Buffer In The Sga?

Answer»

Yes, but indirectly. The SIZE of the Flashback Buffer is set to 2 * LOG_BUFFER.

For performance reasons, it’s recommended to set LOG_BUFFER to at least 8MB for

databases running in Flashback Mode.

UPDATE: For LARGE 11.1.0.7+ databases with more than a 4GB SGA, you may consider SETTING LOG_BUFFER to values in the range of 32-64 MB.

Yes, but indirectly. The size of the Flashback Buffer is set to 2 * LOG_BUFFER.

For performance reasons, it’s recommended to set LOG_BUFFER to at least 8MB for

databases running in Flashback Mode.

UPDATE: For large 11.1.0.7+ databases with more than a 4GB SGA, you may consider setting LOG_BUFFER to values in the range of 32-64 MB.