Prev: trouble with RAC db start
Next: orion tool errors (storax_aiowait)
From: joel garry on 22 Oct 2007 14:20
On Oct 22, 10:22 am, Frank van Bortel <frank.van.bor...(a)gmail.com>
wrote:
> Eric von Horst wrote:
> > Hi,
>
> > I need some general advise on tuning.
>
> Why?
>
> There's absolutely nothing in your post that leads to
> anything to be said (apart from the obvious: state your version
> including 5th decimal, start looking where anything might be wrong).
>
> You're not suffering from ODCTD, are you?
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

I'm with Ian - 4GB with db_block_buffers=2000? Red flag, not
obsessiveness. In general, reviewing things that obviously haven't
been tuned is not obsessive. Periodically reveiwing isn't obsessive.
Trying to get the last little bit of SGA filled, that's obsessive.

jg
--
@home.com is bogus.
"CLARIFICATION: EVACUEES ARE DIRECTED TO QUALCOMM STADIUM NOT QUALCOMM
OFFICES." - San Diego emergency notification.

From: Frank van Bortel on 23 Oct 2007 15:37
joel garry wrote:
> I'm with Ian - 4GB with db_block_buffers=2000? Red flag, not
> obsessiveness. In general, reviewing things that obviously haven't
> been tuned is not obsessive. Periodically reveiwing isn't obsessive.

No, I agree on that - but there is no indication
in the original post as to why:
* No user complaints
* No mention of reports all of a sudden taking 10 times longer,
* nor any screens,
* nor any other query

And why would db_block_buffers = 2000, in combination
with 4GB memory on the machine raise a flag?

Lots of assumptions here...
--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
From: joel garry on 23 Oct 2007 19:31
On Oct 23, 12:37 pm, Frank van Bortel <frank.van.bor...(a)gmail.com>
wrote:
> joel garry wrote:
> > I'm with Ian - 4GB with db_block_buffers=2000? Red flag, not
> > obsessiveness. In general, reviewing things that obviously haven't
> > been tuned is not obsessive. Periodically reveiwing isn't obsessive.
>
> No, I agree on that - but there is no indication
> in the original post as to why:
> * No user complaints
> * No mention of reports all of a sudden taking 10 times longer,
> * nor any screens,
> * nor any other query
>
> And why would db_block_buffers = 2000, in combination
> with 4GB memory on the machine raise a flag?
>
> Lots of assumptions here...
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

Maybe I'm unimaginative, but I can't even imagine an SGA that small in
any modern production system. In general, I think any performance
methodology that doesn't take into account looking to see that
everything is configured in the ballpark is limited. I'm pretty sure
I've heard Cary Milsap say something to the effect his methodology is
based on his people's experience, which is that they are only called
in when all the easy and obvious things are fixed.

So grab the low-hanging fruit first!

jg
--
@home.com is bogus.
Check gas gauge before assuming there is nothing wrong.
http://bluepoof.blogs.com/motorcycle/2006/02/new_friends_1.html

From: joel garry on 23 Oct 2007 19:31
On Oct 23, 12:37 pm, Frank van Bortel <frank.van.bor...(a)gmail.com>
wrote:
> joel garry wrote:
> > I'm with Ian - 4GB with db_block_buffers=2000? Red flag, not
> > obsessiveness. In general, reviewing things that obviously haven't
> > been tuned is not obsessive. Periodically reveiwing isn't obsessive.
>
> No, I agree on that - but there is no indication
> in the original post as to why:
> * No user complaints
> * No mention of reports all of a sudden taking 10 times longer,
> * nor any screens,
> * nor any other query
>
> And why would db_block_buffers = 2000, in combination
> with 4GB memory on the machine raise a flag?
>
> Lots of assumptions here...
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

Maybe I'm unimaginative, but I can't even imagine an SGA that small in
any modern production system. In general, I think any performance
methodology that doesn't take into account looking to see that
everything is configured in the ballpark is limited. I'm pretty sure
I've heard Cary Milsap say something to the effect his methodology is
based on his people's experience, which is that they are only called
in when all the easy and obvious things are fixed.

So grab the low-hanging fruit first!

jg
--
@home.com is bogus.
Check gas gauge before assuming there is nothing wrong.
http://bluepoof.blogs.com/motorcycle/2006/02/new_friends_1.html

From: Frank van Bortel on 24 Oct 2007 13:07
joel garry wrote:

> Maybe I'm unimaginative, but I can't even imagine an SGA that small in
> any modern production system.

It is not the SGA - there's 4GB on the machine.

--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: trouble with RAC db start
Next: orion tool errors (storax_aiowait)