Don't forget estat/bstat for the db, and vmstat for the os. Topas
should be able to tell you especially if there is a memory
issue. The only times I've seen AIX choke on an Oracle DB were when
there was an i/o bottleneck (ie exceeding the physical i/o possible
on the hdisks) or when memory started paging. Both of these can be
seen in topas. I mainly use vmstat to look at runnable vs blocked processes.
At 07:45 5/31/2006, you wrote:
>Trace and tkprof are pretty powerful in proving whether the problem is
>application caused or otherwise. With timed_statistics set to TRUE,
>it's pretty easy to show a developer where the application is spending
>its time and why it is getting caught there.
>
>It is a little easier with newer releases having tools like statspack
>and strace or truss on UNIX. But when it is still down to checking a
>specific application I still use trace and tkprof.
>
>Jim Beveridge
>EUR Systems
>(717)697-6800 x333
>Jim.[Email address protected]
>www.eursystems.com
>-----Original Message-----
>From: Michael Porter
>[mailto:oracledba-ezmlmshield-x71397995.[Email address protected]
>Sent: Wednesday, May 31, 2006 8:40 AM
>To: LazyDBA Discussion
>Subject: RE: AIX Users: Performance Consulting
>
>Performance has always been an issue with this application historically.
>It was moved to the current server because the performance on the
>previous one was poor over time. They have not really added any more
>users nor really much in the way of additional data. The ONLY real
>change has been modifications to the application. I have used all of
>the AIX tools such as vmo, ioo, vmstat, svmon, and topas. There is no
>indication that we have a memory problem as we rarely if ever have any
>swapping. The run queue is always maxed out as the sql processes take
>far too long when they run and end up causing a log jamb. We cannot add
>more CPU's and upgrading the current ones is probably a waste of $$$'s
>as we would be better off with a new server (Linux!). I am convinced
>that if the code was properly tuned it would make all the difference in
>the world. But, I am just a DBA and sysadmin so in the eyes of the code
>developers, I don't seem to know much... It's always buy a bigger
>"boat" to fix the application.
>
>M
>
> >>> "Eivers Craig AU "
><oracledba-ezmlmshield-x79763203.[Email address protected] 5/31/2006
>12:19:08 AM >>>
>When did the system performance become an issue, is this and ongoing
>problem or has it just stared? We have the same setup, AIX 4.3.3 on a
>S70 with 7.3.4 We did have a problem a while back, but a little bit more
>RAM helped here. Have you tried running something like >topas while you
>are experiencing the problem. You will soon see if you need more RAM/CPU
>etc.....
>
>:)
>
>-----Original Message-----
>From: Michael Porter [mailto:oracledba-ezmlmshield-x24997014.[Email
>address protected]
>Sent: Wednesday, May 31, 2006 04:01
>To: LazyDBA Discussion
>Subject: RE: AIX Users: Performance Consulting
>
>In my case, at least for the near future, upgrading either the OS or
>ORacle is NOT an option. We have an interface that cannot support it
>yet... 8=(
>
> >>> "Jumma Salim "
><oracledba-ezmlmshield-x52380769.[Email address protected] 5/30/2006
>1:53:09 PM >>>
>Certainly I would second that; but I heard you can't upgrade oracle
>
>-----Original Message-----
>From: John Salverda
>[mailto:oracledba-ezmlmshield-x23601000.[Email address protected]
>Sent: Tuesday, May 30, 2006 1:07 PM
>To: LazyDBA Discussion
>Subject: Re: AIX Users: Performance Consulting
>
>We have replaced several (20+) UNIX/Oracle boxes with SQL Server
>boxes,
>and
>this is what we found...
>Performance depends largely on how the OS is kept up. Many of the
>boxes
>we
>replaced had nearly full drives; the OS was struggling to find places
>to
>put
>the data.
>This was neither an OS nor an Oracle problem but an upkeep problem
>onsite.
>Data simply was not being backed up and removed from the systems, and
>temporary files were clogging up the drives. On other boxes where
>there
>was
>plenty room, performance was great.
>Since you already have Oracle, simply upgrade the OS and Oracle. If
>possible, a new box (more disk space) would be good, too...
>
>
>WJS
>----- Original Message -----
>From: "Jumma Salim"
><oracledba-ezmlmshield-x63412295.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Sent: Tuesday, May 30, 2006 9:06 AM
>Subject: RE: AIX Users: Performance Consulting
>
>
> > Outsider consultant will have more problem with this political
>issues
> > now both the side will gang up against the contractor
> >
> >
> > -----Original Message-----
> > From: Michael Porter
> > [mailto:oracledba-ezmlmshield-x18777411.[Email address protected]
> > Sent: Tuesday, May 30, 2006 11:38 AM
> > To: LazyDBA Discussion
> > Subject: AIX Users: Performance Consulting
> >
> > We are possibly looking to bring in someone that has expertise in
> > evaluating Oracle running on AIX. We are sort of in a position for
>one
> > of our legacy systems in which the application vendor says it's the
> > server/AIX that is causing poor performance when Oracle stats
>clearly
> > show sql/plsql inefficiencies. It is turning into a "she said he
>said"
> > finger pointing and we would like to entertain some outside,
>independent
> > eyes to take a look and possibly help narrow down the real issue.
> > Unfortunately the app is on Oracle 7.3.4 (mainly webdb and plsql
>mix)
> > and AIX 4.3.3, BOTH no longer really supported and, tools to
>evaluate
> > them are far and few. If anyone has any suggestions for
> > companies/consultants that might have an interested I would
>appreciate
> > it.
> >
> > Mike
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> >
> >
> > --------
> > website: http://www.LazyDBA.com
> > Please don't reply to RTFM questions
> > Oracle documentation is here: http://tahiti.oracle.com
> > To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> > To subscribe: see http://www.lazydba.com
> > By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>
>========================================================
>CONFIDENTIALITY NOTICE
>
>This message and its attachments (if any) may contain confidential,
>proprietary or legally privileged information and it is intended only
>for
>the use of the addressee named above. No confidentiality or privilege
>is waived or lost by any mistransmission.
>
>If you are not the intended recipient of this message you are hereby
>notified that you must not use, disseminate, copy it in any form or
>take
>any action in reliance on it. If you have received this message in
>error,
>please, delete it (and any copies of it) and kindly inform the sender,
>of this
>e-mail, by replying or go to www.prysmian.com on "contact us".
>========================================================
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page