| CPU Bound machine [message #369209] |
Thu, 18 May 2000 08:48  |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
One of my systems is a 4 way machine with 2 Gigs of memory. But it is cpu bound. There are often 150+ users logged in, plus other internal processes connecting to other databases.
My thoughts are that multi-threaded server should help the situation, since user are waiting now for cpu, so if they have to wait in the mts it will not be worse, and mts would allow oracle and the process that are running to get work done without being interferred with by the O/S.
Any thoughts or feedback on this would be most welcome
thanks
|
|
|
|
| Re: CPU Bound machine [message #369214 is a reply to message #369209] |
Fri, 26 May 2000 18:11  |
Thomas
Messages: 67
Registered: September 1999
|
Member |
|
|
Hi Peter,
you did not mention which version of oracle u use.
Oracle has improved the power of mts in V8.
For users doing OLTP-Stuff I would recommend to use it since you need much less Processes on the UNIX Box which consumes ressources although the process is almostly waiting for the user.
For Batch Process I recommend to use a connect string that forces a dedicated session.
You can easily use both kinds of connection and try it.
regards, Thomas
|
|
|
|
| Re: CPU Bound machine [message #369215 is a reply to message #369214] |
Tue, 13 June 2000 12:07 |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
Thomas,
Thanks for the comments.
We use oracle 7.3 and the system behaves very
much like OLTP. It has a system which manages Workflow, and consistently logs in, does a couple of database updates, and then promptly logs out.
I will try it out as soon as I can.
Thanks again for your comments
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
