Re: Excessive Paging - AIX Related?

You can set your buffer size to 10000 and put commit=y into your parfile. This may help.

Happy Holidays,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 20, 2001 1:35 PM

> Sorry for the cross post if you are the other big list.
>
> I am having some trouble finding a solution to a problem. This is
> specifically AIX related. Here is the gist.
>
> * Any large sort or import appears to cause paging to take place. I only
> say large because of the problems, in reality these are quite small
objects
> for the machine we are running, 200,000 - 600,000 rows in the 200-400 MB
> range. Any way last night I was importing one of these objects.
>
> * CPU wio goes through the roof almost right away. Spending up to 50% of
> time waiting on IO.
>
> * vmstat shows huge numbers in po, fr, sr and a few block processes in b
> column.
>
> * hdisk0 goes 100% (swap space is here)
>
> * lsps -a shows swap space is only 40% utilized, never changes. There is
> only 2GB of swap, admin just increase to 4 GB but still on same disk. Not
> sure this will really help since it never was 100% anyway.
>
> * Setup- RS/6000 7026-M80 rack mount running AIX with 4-500Mhz processors,
> 4GB memory, 3-10/100 Ethernet cards, 2 fiber ports, and 2-18.2GB internal
> drives with RAID. The 2 fiber ports will attach to a storage area network
> providing access to EMC Clarion storage (see below)
>
> * Oracle is the only app on the box and I have configured about 2GB for
the
> SGA. There should be plenty of free memory.
>
> I am pretty sure we hosed something up with are memory configuration. I
see
> a lot of things about using vmtune to configure various AIC related
> parameters as too how much memory is can use for various things. Can
anyone
> provide me with the direction to head in examining our configuration and
> what settings should/could be changed to improve the situation?
>
> Thanks,
> Ethan Post
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
> INET: Ethan.Post_at_ps.net
>
> 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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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