Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: log_buffer, redo buffers, and show sga
On 26 Feb 2004 08:19:34 -0800, i_rahim_at_hotmail.com (Imran Rahim)
wrote:
>Hi, why is there a difference between
>Redo Buffers when I type show sga (319488),
>log_buffer in init.ora (163840)
>and log_buffer in v$sgastat (295936)?
Likely this will only occur when you didn't startup the database using the init.ora you are currently looking at. Other than that those numbers don't make any sense
-- Sybrand Bakker, Senior Oracle DBAReceived on Thu Feb 26 2004 - 11:27:36 CST