Help with Tuning?

From: Steve - Schow <sjs_at_shell.portal.com>
Date: 19 Sep 1994 23:48:13 GMT
Message-ID: <35l7vt$i4e_at_news1.shell>

Hi all,

we have an application that is going to require hundreds or even thousands of con-current users. These users will mosly just be making very small query transactions and occasional update and insert transactions. My question is, what is the best way to tune oracle and the SQL statements in order to attain good performance. Right now, a single transaction is taking about a second. Obviously if 3000 users were connected at the same time, then 3000 seconds would be WAY too long to wait for a query which only returns 1 row!!!!

Any and all insights regarding this would be VERY helpful.

Also, it so happens that the thousands of concurrent users will be using the same oracle login id. So, are there any resource limits that we need to make sure to beef up in order to handle that many instances of a single user being logged in at the same time and performing concurrent transactions?

Thanks much in advance

-steve

--

---

Steve Schow | But you don't need to use the claw sjs_at_corp.portal.com | if you pick the pear with the big 408-973-9111 | paw paw. Have I given you a clue? Received on Tue Sep 20 1994 - 01:48:13 CEST