Gene,
thx...for me, I would tying the IBM
SAs up and asking about everything they
see or touch. I'm like that.
You got me confused....they are *raising*
BUFPCT b/c your *oracle* hit ratio is high
enough? if so, that's reasonable, but I still
would want to know about how SAS is acting,
rather than "backing into" tuning it by
saying oracle is doing ok.
the sar flags are fine. you might find some
value in Sequent's version of top. it might
even be loaded by default in your version.
Also, try swap -[l|..] to look at swap....
lastly, there is ALOT more to paging, etc
than BUFPCT, but.....i am too freaking lazy
to write about it now...nuff said to say
worry alot more about the page OUTs than
the page INs....nuff said....
hth
Ross
-----Original Message-----
Sent: Friday, June 22, 2001 3:43 PM
To: Multiple recipients of list ORACLE-L
Ross,
I'm not sure why it is being done. We had an audit of
our systems done by IBM people and that's one of their
recommendations. I think their logic is "you hit ratio
is pretty high - 99% - so you can do with less
memory".
This server is not a dedicated Oracle server, we are
running another application (SAS) on it.
I have been running sar -wpr to get info on paging,
swapping and unused memory. Does this make sense to
you?
thank you
Gene
--- "Mohan, Ross" <[EMAIL PROTECTED]> wrote:
> 1) use sar on SVR4 systems....vmstat is a BSD thing
> 2) DYNIX rocks
> 3) IMHO yer BUFPCT is too high. If this is a
> dedicated database server ( i.e. no other apps on it
) and you are using ptx's DirectIO ( check with yer
SA,
or run truss on a shadow ) you really don't need much
more than 10. YMMV, etc.
> 4) You never mention WHY you are tweaking kernel
> params.What is going on?
>
>
>
> -----Original Message-----
> Sent: Friday, June 22, 2001 11:17 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi all
>
> We are running oracle 8.1.6 on DYNIX 4.4.7.
> CUrrently the BUFPCT is set to 25 and during this
> weekend will be increased to 30. I'd like to be
> able to check whether this affects oracle in any
> way.
> What statistics should I be looking at? I was
> thinking
> of using a vmstat (to check of page-outs ) but it
> doesn't exist on DYNIX. Any ideas?
>
> thanks
=====
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Gurevich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Mohan, Ross
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
