Re: SGA question

What can I say?

I am clearly an evil bastard, lacking all integrity and honour.

Obviously, I should be cast out of the Garden of Eden into the hellfires of Gehenna (or the nearest Developers' Conference, whichever is the nearer).

Mea culpa, mea maxima culpa.

For pennance, I promise not to attempt humour again, especially after a week spent explaining the mysteries of Backup and Recovery to assorted paying customers, some 45 posts here in my spare time, and 25 detailed emails to people who've sought my advice (for free). And especially in the presence of someone who clearly wouldn't understand the meaning of the word 'wit' if it painted itself purple, and danced naked on the top of a harpsichord singing 'witty days are here again'.

In short, you are entitled to your opinion that I made someone a laughing-stock, and I disgree with it.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Karen" <karen.abgarian_at_fmr.com> wrote in message
news:39FB0A70.1F8D0740_at_fmr.com...


> The original poster did, of course, a mistake sizing his shared pool. But

 I see


> little

> honour in making a laughin'-stock out of him just because you happen to

 know


> more about this particular subject.

>

> Regards

> Karen Abgarian

>

>

> "Howard J. Rogers" wrote:

>

> > "sowhat" <sowhat_at_yahoo.com> wrote in message

> > news:39FA60E5.54A04997_at_yahoo.com...

> > > 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 :-)

> > >

> >

> > Cruel is as cruel does.

> >

> > And no, I haven't a clue what that means, so it must be profound (yikes,

> > I've just slipped into developer-mode!!)

> >

> > Stop It!!

> >

> > Ah.  That's better.  I'm back in DBA mode, so...

> >

> > If I offended anyone with my pathetic attempts at cruelty, er... I mean,

> > humour, I apologise.  Profusely.

> >

> > <Uncross fingers from behind back>

> >

> > Will that do?

> >

> > ;-)

> > HJR

> >

> > > "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?

> > > > > > >

> > > > >

> > >

>