| regarding SESSION parameter [message #407079] |
Mon, 08 June 2009 06:34  |
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
|
Member |
|
|
I am going to increase the SESSION parameter of the database from 720 to 1200.
Is there any chance that it makes any problem in the database?
Do I need to increase the process parameter as well with this?
Any suggestion please.
|
|
|
|
|
|
|
|
| Re: regarding SESSION parameter [message #408009 is a reply to message #407079] |
Fri, 12 June 2009 23:26  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
| rumman wrote on Mon, 08 June 2009 18:34 | I am going to increase the SESSION parameter of the database from 720 to 1200.
Is there any chance that it makes any problem in the database?
Do I need to increase the process parameter as well with this?
Any suggestion please.
|
1. You should follow BlackSwan's guide, it's most important to measure that how about enough session/process in your Database.
2. Oracle recommends:
Session:=(1.1*Processes)+5
than, you've got 700 sessions, and your processes in DB is about 631.
Regard!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
