| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Shared server tuning
Hi Aaron,
Whether or not MTS is causing your problems, you should probably switch to dedicated sessions anyway. MTS is a lot of overhead for 30 users.
Do you have a test or development system to try this on first?
You just need to ensure that you understand the tnsnames.ora file configuration.
Or just use netmgr to do the config, it works pretty well.
If not, you can always setup tnsnames.ora to accept both dedicated and shared server connections, depending on the alias used.
As for the performance problem, have you run a 10046 trace?
While this will show what your sessions are waiting on, and how long they are waiting, it is complicated a bit by the MTS connections.
The trace file will have multiple sessions in it.
You could query v$session_wait while you *know* that a session is waiting:
select
s.username username, e.event event, s.sid, e.p1text, e.p1, e.p2text, e.p2, e.wait_time, e.seconds_in_wait, e.state
and s.sid = e.sid
order by s.username, upper(e.event);
Not as good as a trace file, but better than nothing, and a place to start.
HTH Jared
"Sentell, Aaron" <aaron_sentell_at_tempe.gov>
Sent by: oracle-l-bounce_at_freelists.org
06/09/2004 04:53 PM
Please respond to
oracle-l_at_freelists.org
To
oracle-l_at_freelists.org
cc
Subject
RE: Shared server tuning
First of all, thanks to everyone for their responses so far. Your input is very much appreciated.
So now I'm talking about and considering changing this instance over to
use
dedicated connections, but before I charge ahead "blindly" I would like to
have a valid reason for doing this rather than just crossing my fingers
and
hoping MTS is the problem.
...
Any input would be greatly appreciated.
Thanks!
Aaron
 |
 |