RE: Monitoring Memory on DYNIX

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 22 Jun 2001 13:01:41 -0700
Message-ID: <F001.00334535.20010622130604@fatcity.com>

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" <MohanR_at_STARS-SMI.com> 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: g_u_r_e_v_i_c_h_at_yahoo.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: Mohan, Ross
  INET: MohanR_at_STARS-SMI.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).

Received on Fri Jun 22 2001 - 15:01:41 CDT