troubleshooting Question

Oracle Configuration Parameters

Avatar of richkeegan
richkeegan asked on
Oracle Database
4 Comments1 Solution503 ViewsLast Modified:
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
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros