Oracle Configuration Parameters

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
richkeeganAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

seazodiacCommented:
Using MS MTS to access oracle:

try to set these parameter to a larger value, considering you have 100+ users...

You need to set these values in INIT<SID>.ORA FILE on the database server:


sessions = 600
distributed_transactions = 600
open_cursors =1000
processes =600


You need to restart the database by shutdown immediate so that these changes will take effect.


you also need to set the QUEUESIZE in the LISTENER.ORA file on the database server

QUEUESIZE = 150


and then restart the listener process
by

lsnrctl stop
lsnrctl start
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
riazpkCommented:
And also how many dispatchers are there ???

Are you seeing lots of INACTIVE sessions in Your V$session view ?
0
seazodiacCommented:
There won't be any dispatchers....

MTS here means Microsoft transaction service....
0
riazpkCommented:
Ohh sorry !

I thought it was Multi-threaded Server

:(

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.