Re: Excessive Paging - AIX Related?

One thing that jumps right out is 50% IO waits.

You need to find out which disk(s) are so overloaded.

Analyze the stats from v$filestat to see what's going on at the database level.

Q: Why is your SGA 2 gig, and how is it partitioned?

db_block_buffers:

shared_pool:
other pools:

Jared

                                                                                       
                             
                    "Post, Ethan"                                                      
                             
                    <Ethan.Post_at_ps       To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    .net>                cc:                                           
                             
                    Sent by:             Subject:     Excessive Paging - AIX Related?  
                             
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    12/20/01 10:35                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L                                                        
                             
                                                                                       
                             
                                                                                       
                             

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: 
  INET: Jared.Still_at_radisys.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).