Re: SGA question

Understood, and point well received.
However, I wonder if they were really serious....looks like they posted twice, with the second in a joking manner.
Don't see how 35 MB of redo generation would cause the need for 235MB of redo log buffer :-). WOW.

You were a little cruel, if they weren't joking tho :-)

"Howard J. Rogers" wrote:

> It wasn't the SGA per se that had me in stitches, but the size of the Redo
> Log Buffer. As I said, the biggest I've ever seen was 10Mb or so, and even
> that was too big... and that was on one hell of a busy database.
>
> Based on the figures supplied (and I warrant my maths may be dodgy), but his
> Shared Pool is actually smaller than his Log Buffer. If that's properly
> tuned, I'll chew my left arm off. Slowly.
>
> Regards
> HJR
> --
> --------------------------------------------------------------------------
> Opinions expressed are my own, and not those of Oracle Corporation
> Oracle DBA Resources: http://www.geocities.com/howardjr2000
> --------------------------------------------------------------------------
>
> "sowhat" <sowhat_at_yahoo.com> wrote in message
> news:39FA066E.6412CC4C_at_yahoo.com...
> > Altho one could always reply, why have 8X8 machines for Oracle Database
 Servers
> > if you are only going to use 100MB for the SGA.
> > I've actually seen situations with larger SGA's before -- pretty heavy
 databases
> > tho.
> >
> > "Howard J. Rogers" wrote:
> >
> > > "Yo" <Yo_at_ibm.net> wrote in message news:39F9D226.6659C26B_at_ibm.net...
> > > > Our SGA is sized:
> > > >
> > > > Total System Global Area 937877008 bytes
> > > > Database Buffers 524288000 bytes
> > > > Redo Buffers 235945984 bytes
> > > >
> > >
> > > Thanks for this. I haven't had such a laugh for ages.
> > >
> > > Oh -but, you were being serious? You mean, you honestly have 937Mb SGA?
 In
> > > addition to a 525Mb Database Buffer Cache? Impressive stuff if so.
> > >
> > > But the funniest thing has to be that Redo Log Buffer. All 235Mb of it!
> > >
> > > Hilarious. This I must use on my next DBA course.... I think 10Mb is
 the
> > > biggest I've ever seen in my life before, and even that was too big.
> > >
> > > Cheers, I enjoyed it.
> > > HJR
> > >
> > > > This is for about the same size database -- generating about 35 MB of
 redo
> > > > every 15 minutes -- only one user, but a very busy user logging
 network
> > > > events from a app.
> > > > Yours looks a little small....but can't say for sure.
> > > > I've never dealt with an SGA smaller than, say 500MB.
> > > >
> > > >
> > > > Yo wrote:
> > > >
> > > > > Hi, just started a new job.
> > > > > Running Oracle 8 on Solaris 2.6.
> > > > > 8X8 E4500 with Fibre Channel disk arrray attached.
> > > > > Redo Generation on one of the main larger (100+ GB) Databases is
 about
> > > > > 50MB every 10-15 minutes.
> > > > > Typically anywhere from 100-200 user connections performing various
> > > > > transactions -- mix between read and write.
> > > > > Also some batch processes running that pull data into other
 databases
> > > > > from this particular instance.
> > > > >
> > > > > Boss told me there was some need for some performance tuning.
> > > > >
> > > > > I've been poking around for a couple of days, and right off the bat
 I
> > > > > noticed something odd....
> > > > >
> > > > > This is the size of the SGA, of which I have never been involved
 with a
> > > > > Database SGA sized so small.
> > > > >
> > > > > Total System Global Area 116170256 bytes
> > > > > Fixed Size 48656 bytes
> > > > > Variable Size 45326336 bytes
> > > > > Database Buffers 65536000 bytes
> > > > > Redo Buffers 5259264 bytes
> > > > >
> > > > > Opinions?
> > > >
> >
Received on Sat Oct 28 2000 - 00:15:17 CDT