<div>
And also how many dispatchers are there ???<br />
<br />
Are you seeing lots of INACTIVE sessions in Your V$session view ?
</div>


And also how many dispatchers are there ???

Are you seeing lots of INACTIVE sessions in Your V$session view ?

<div>
There won't be any dispatchers....<br />
<br />
MTS here means Microsoft transaction service....
</div>


There won't be any dispatchers....

MTS here means Microsoft transaction service....

<div>
Ohh sorry ! <br />
<br />
I thought it was Multi-threaded Server<br />
<br />
:(<br />
<br />

</div>


Ohh sorry !

I thought it was Multi-threaded Server

:(



<div>
<div class="content wysiwyg-content">
Hi,<br />
I was wondering what the relevant memory usage of each of the following (if relevant) was and what the settings should be for my environment and server:<br />
<br />
sessions<br />
distributed_lock_timeout<br />
distributed_transactions<br />
dml_locks<br />
max_transaction_branches<br />
open_cursors<br />
processes<br />
queuesize<br />
<br />
There are approximately 100 users accessing the system at the moment via mts (I'm not sure how many connections this is holding for the com+ objects) - which sporadically receive a &quot;can not enlist transaction&quot; error. Hence my thoughts that maybe some of these resources need to be upped from the lower part of:<br />
<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mts/settingup_4vdx.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mts/settingup_4vdx.asp</a><br />
<br />
I've got no idea as to what the &quot;max&quot; I can safely set these too or so forth. The server is:<br />
<br />
dual xeon 2.4, <br />
3gb of ram. <br />
c: 4gb - 4MEG free (this wasn't me that installed it on such a small partition)<br />
d:131gb - 101gb free<br />
<br />
Thanks,<br />
Rich
</div>
</div>


Hi,
I was wondering what the relevant memory usage of each of the following (if relevant) was and what the settings should be for my environment and server:

sessions
distributed_lock_timeout
distributed_transactions
dml_locks
max_transaction_branches
open_cursors
processes
queuesize

There are approximately 100 users accessing the system at the moment via mts (I'm not sure how many connections this is holding for the com+ objects) - which sporadically receive a "can not enlist transaction" error. Hence my thoughts that maybe some of these resources need to be upped from the lower part of:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mts/settingup_4vdx.asp

I've got no idea as to what the "max" I can safely set these too or so forth. The server is:

dual xeon 2.4, 
3gb of ram. 
c: 4gb - 4MEG free (this wasn't me that installed it on such a small partition)
d:131gb - 101gb free

Thanks,
Rich

Oracle Configuration Parameters

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.