I would say by what you are saying is.. you need more ram.. either physically, or given to oracle.. I would recommend bringing up your shared ram settings.. and check your I/O as you test.. What I do is Test with imports, and reports against a DB, Bring the Ram settings up to where the I/O is gone.. Then watch and test again till you get a Good feeling for what the issue is..
If you are using all your ram already -- i suspect.. Well time to go to the store and get more.. I would recommend at least 4 or 6 gig for a server. hope that helps some/. On 10/11/06, Alex Salgado <[EMAIL PROTECTED]> wrote:
** Hi list I have problems with the performance of my ARS Server. I need advices or experiences to improve the performance. My environment is: ARS Server 6.3 Remote DB with Oracle 9i OS Red Hat Linux Enterprise 3 2 GB RAM My thread config. is min:2, max:6 list and fast. My current users are 65 so so. My main table (SPRT:Issue, Customer Support App) have 370,000 records, and 1 unqualified query in this table take 3:30 minutes. And in general the System is slow when I search and Submit. I got the SQL and API logs and I analized them with ARLogAnalizer, but I can´t find the problem. Thanks in advance Alex Salgado __20060125_______________________This posting was submitted with HTML in it___
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
