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
Oracle LazyDBA home page