Re: Oracle on AIX hangs
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: Brandon.Allen@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 27 Jan 2006 04:09:51 -0800 (PST)
what type of connect are you erforming is it an application conenction
(wensphere etc)
or just plain sqlplus connection.
seems like you box is unable to handle the resources you are requesting.
or there are some rogue statements in the app code that you are tryingto run.
from 8.1.7 to 9.2 there were alot of optimizer changes that mess up a lot of
code if not tested properly.
it seems that you upgraded and migrated at the same time.
check the sql explain plans.
maybe you might want ot change optimizer_features_enable to 6.1.7.4 and see
if that helps you in the short term.
"Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx> wrote:
Anyone else seen anything like this?
Oracle 9.2.0.6, AIX 5.2 ML7
Recently migrated to new server, from Oracle 8.1.7 & AIX 5.1, and since
moving to the new server we've had a few instances of horrible performance
where hdisk0 is pegged at 100% utilization. When this happens it takes 60
seconds just to establish a telnet connection and all Oracle sessions, as well
as new connection attempts just hang indefinitely. We can't even get a "conn /
as sysdba" connection so we can't get a hanganalyze or systemstate dump.
After we killed all database server processes (not the background processes),
the hdisk0 utilization dropped down to zero, but then as soon as we try to
connect again, the connection attempt hangs and hdisk0 goes back to 100%. We
can't even shutdown the instance since we can't connect so we have to kill it,
and then the problem goes away and does not come back when the instance is
restarted . . . until the next time, which may be days or weeks later. We
haven't been able to identify any pattern to the occurrences yet.
I've been all over Google and Metalink with no luck.
Any ideas?
Thanks,
Brandon
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts:
