Ali,
You should perhaps start with the database. Whenever I have seen similar
issues, it has always been that the queries the application is running are
not responding fast enough. Under load, where the requests are not returning
fast enough, IAS will start up more and more connections and eat the
machine. If you can identify the main queries the application is running and
tune them (i.e. better indexes, better SQL, analyze the tables, etc) then
you should find the loading on the IAS layer reduces a lot.
HTH
John.
-----Original Message-----
From: Ali Faour
[mailto:oracledba-ezmlmshield-x87760684.[Email address protected]
Sent: 05 July 2006 09:23
To: LazyDBA Discussion
Subject: Performance in 9ias
Hi All,
We are facing a major performance issue in 9iAS.
We have a very good server machine where 9iAS installed (16GB RAM, 4CPU...
We are using Oracle 9i Database 9.0.2.6 and 9iAS 9.0.2 Rel 2.
The performance is acceptale during the normal load transactions and no.
of users.
It becomes unacceptable during the heavy working 2 hours at the morning
where the cpu is 100% full.
Can anyone inform me about any 9ias tuning parameter to increase the
performance ?
Regards,
Ali Faour
--------
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
-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.
Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.
SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.
Oracle LazyDBA home page