Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: log_buffer, redo buffers, and show sga

Re: log_buffer, redo buffers, and show sga

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 26 Feb 2004 18:27:36 +0100
Message-ID: <k2bs30t4ijkd01hubt3sainlp3m94f67ot@4ax.com>


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 DBA
Received on Thu Feb 26 2004 - 11:27:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US