Database parameters: processes vs sessions vs transactions?
Hi,
I once (1or 2 years ago) read some information regarding how the parameters processes, sessions and transactions were related, but now I unfortunately cannot find that information =(
As I recall it, and looking on my current numbers, I guess that sessions might (should?) be based on the number of processes times a factor, and transactions is based on the value of sessions times a factor, leaving me with something like:
processes =any value good for my environment
sessions=1.15 x processes
transactions = 1.1 x sessions
Am I anywhere close to a good analysis here, or have I mixed up any definitions? Is there any recommended "rules"/best practices for setting these values? (As I recall it, my initial problem was too low values for either processes or sessions, and I later found out that I also should increase transactions)
I once (1or 2 years ago) read some information regarding how the parameters processes, sessions and transactions were related, but now I unfortunately cannot find that information =(
As I recall it, and looking on my current numbers, I guess that sessions might (should?) be based on the number of processes times a factor, and transactions is based on the value of sessions times a factor, leaving me with something like:
processes =any value good for my environment
sessions=1.15 x processes
transactions = 1.1 x sessions
Am I anywhere close to a good analysis here, or have I mixed up any definitions? Is there any recommended "rules"/best practices for setting these values? (As I recall it, my initial problem was too low values for either processes or sessions, and I later found out that I also should increase transactions)
1