Re: Slow Response Time

From: John F Riordan (jriorda2@CSC.COM)
Date: Fri Dec 20 2002 - 10:53:37 EST


Hi Linda,

We have several Oracle Servers including a 660. As I have been learning
there are a few things I have done to make performance better. There is
some great information on Oracle tuning for AIX/RS6000's in the following
redbook.

 http://www.redbooks.ibm.com/redpieces/pdfs/sg245511.pdf

Hope this helps for your situation

John

John F. Riordan
Unix Systems Administrator
Computer Sciences Corporation
207.442.1094
jriorda2@csc.com

                      "Calderon,
                      Linda" To: aix-l@Princeton.EDU
                      <CalderonL cc:
                      @GOALAMO.COM> Subject: Slow Response Time
                      Sent by: IBM AIX
                      Discussion List
                      <aix-l

                      12/20/2002 10:29
                      AM
                      Please respond
                      to IBM AIX
                      Discussion List

We just implemented a P660 with 2 CPU's 550 MHz and 3 GB of RAM. Running a
Oracle 8.1.7.3.0 database with 920 MB SGA, slow response time when running
imports. We notice high CPU consumption and high rate of paging. Server is
on AIX 4.3.3, any suggestions what we should be looking at?

Linda Calderon



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:25 EDT