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