RE: SGA QUESTION

And there is no formula for setting Log Buffers based on the Size of the SGA.
What you have got is okay.
I would suggest monitoring v$system_event for log buffer space wait event, and increase log buffer size if there are consistent waits for this event.

Regards,

• Kirti

> -----Original Message-----
> From: Jared Still [SMTP:jkstill_at_cybcon.com]
> Sent: Saturday, June 23, 2001 3:30 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: SGA QUESTION
>
>
>
> Hoo boy! That's a pretty healthy SGA you got there.
>
> Why do you think you need to dedicate that much RAM
> to your SGA?
>
> Why not start with something more reasonable, like say,
> 200 meg for shared pool and 200 more for the database
> buffers?
>
> A large shared pool can actually impede performance.
>
> Jared
>
>
> On Saturday 23 June 2001 12:20, Bunyamin K. Karadeniz wrote:
> > Hi GURUS,I HAVE A QUESTION.
> >
> > I will newly create a database and I have 8 GB RAM.
> >
> > I will create my SGA as 1 GB . IS it a good Idea?
> > I see that there is a variable size for the SGA , How can I arrange
> that?
> > How much must be log buffers for a 1GB SGA?
> > Thanks .
> > BUNYAMIN
> >
> > STARTUP
> > ORACLE instance started.
> > Total System Global Area 51168524 bytes
> > Fixed Size 70924 bytes
> > Variable Size 34242560 bytes
> > Database Buffers 16777216 bytes
> > Redo Buffers 77824 bytes
>
> ----------------------------------------
> Content-Type: text/html; charset="iso-8859-9"; name="Attachment: 1"
> Content-Transfer-Encoding: quoted-printable
> Content-Description:
> ----------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).