We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Oracle Configuration Parameters

richkeegan
richkeegan asked
on
Medium Priority
494 Views
Last Modified: 2011-04-14
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
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2004
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Ora_TechieDatabase Administrator
CERTIFIED EXPERT

Commented:
And also how many dispatchers are there ???

Are you seeing lots of INACTIVE sessions in Your V$session view ?
CERTIFIED EXPERT
Top Expert 2004

Commented:
There won't be any dispatchers....

MTS here means Microsoft transaction service....
Ora_TechieDatabase Administrator
CERTIFIED EXPERT

Commented:
Ohh sorry !

I thought it was Multi-threaded Server

:(

Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.